From: Jon Nangle Date: 09:22 on 12 Jan 2007 Subject: VBA So I've been running iozone, and I've got an .xls file as output with some numbers in it. Sweet. Now I start to think about visualising all of this data, and oh look, there's a message on the iozone web page which says: Contact XXXXXX@xxxxxx.xxx to purchase the Excel spreadsheet with extensive Visual Basic macros to automatically generate the 3D graphs. "Purchase"? Nah. That's for the birds. I can bash that out in no time. How hard could it be? 3 hours later, I find out that you have to do: chart.SetSourceData dataRange chart.ChartType = xlSurface UNDER NO CIRCUMSTANCES should you do: chart.ChartType = xlSurface chart.SetSourceData dataRange or you'll get a helpful "1004 (Object Failed)" runtime error. Not that it's documented anywhere. And oh yeah, if you're drawing other types of chart, it doesn't give a shit which order you do things in. What a piece of crap. Look, I'm sorry. Next time, I'll pay for the spreadsheet. Just make the pain stop. PS: VBA, either use objects, or don't. Don't provide objects for all your stupid Office crap like Balloons, but not for things that people might actually want to use, such as strings. That's just fucking annoying. Your object browser may be craptacular, but it beats searching through your shitty help files hands down.
Generated at 10:26 on 16 Apr 2008 by mariachi