View Single Post
  #1  
Old February 15th, 2006, 10:07 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default embedding a macro when generating a CSV file

Greetings!

I have a recorded macro for a chart of data in an excel file.
Now the question is - how does one generate a CSV file with
that macro embedded to generate this chart dynamically.

The CSV file will be generated by a user with a series of
data (columns/rows). The macro is consistent in that it
will generate a chart based upon the SAME column/rows.
The difference is that the values will be in flux.

Generating the CSV file with the data isn't the problem.
How do you then embed the macro code to generate the chart
(for each file being created).

Regards,

Fred