Copy a file

[voodoo]

I think this is probably an easy question and is probably on the board somewhere but this is a bit of an emergency.

I have a macro where I want to copy one Excel file and place the copied file it in a different folder with a different name.

E.g File1.xls copied to File2.xls

The file one is like a template and contains macros that is why I have to copy the whole file because I want to keep those macros in the new file. So I cant just copy the sheet.

Thanks

 

[zacemmel]

Record a macro that does a "save as" as a different name and then just work off of that. Should find it to be rather painless.

Questions?

http://www.excelquestions.com