Macro that creates another file with macros

[dualhcsniatpac]

I have a file that I want to put a macro in that will create another file that has macros in it to create charts.

Is this possible?? Is there a tutorial on this somewhere?

 

[Andrew Poulsom]

You can put your chart creation macros in a template(xlt) and open a copy of that. See:

http://www.ehow.com/how_13117_create-spreadsheet-template.html

 

[dualhcsniatpac]

Hmmm good idea. Thanks. I think that is better than what I was thinking in the first place.