Creating excel files using VBA

[sameerce]

Hi,
I am working on a VB application which will export the results to a
Excel file. The Excel file generated should also have graphs in it.
To do this I am planning to have a excel file already existing on th
hard drive path which will be having the graphs with reference t
certain rows and columns. The application should make a copy of th
file, rename it and put the file at the same path as the original one
Later on the application should change the results obtained dynamicall
in the workbook, so that the graphs are changed accordingly.

Can anyone tell me how can I make copy of a existing excel file, renam
and save it.

Thanks in advance,

Samee

 

[jaf]

Hi,
application.savecopyas "machinename\shareddrive\path\filename.xls"

But what you really need is called a template.
file>save as> select "template" as the file type in the drop down box.

Turn on the macro recorder and do...
file>new select the template file.
And you have the code.