Posted by steve mielnicki on February 01, 2002 11:15 AM
I would like to export a chart as a GIF.
I'm adding an XLT template file before reading
in my data from file. From VBScript using ActiveSheet and
ActiveChart, I get blank graphs.
this does not work
If I import External Data from a text file from
the Excel menu, the chart draws itself automagically.
But using the VB from the recorded macro yields
a blank graph, which tells me that maybe I have
not identified the Chart object correctly.
How do I identify the chart in the new worksheet
and access it, getting it to draw the graph ?