embedding a macro when generating a CSV file

[Guest]

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

 

[Tushar Mehta]

You cannot have a macro in a CSV file. By definition the CSV format is
meant to facilitate transfer of data between different environments. It
cannot have something unique to XL in it.

What you should do is add a subroutine that first opens a particular file,
probably by asking the user for what file (see the GetOpenFilename method).
Now, the existing macro should become another so that "operates" on any
specified file, probably passed to it as an argument.

The net result is that you can open any workbook (csv or otherwise) and then
whatever you want to this file.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions