VBA

[prev] [thread] [next] [lurker] [Date index for 2007/01/12]

From: Jon Nangle
Subject: VBA
Date: 09:22 on 12 Jan 2007
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 18:01 on 12 Jan 2007 by mariachi 0.52