create macro when creating file

R

Randy

Hi All,
I have one excel worksheet where the macro inside of it
needs to create another file and in the new file, there
needs to be a simple macro that lets the user rename this
file.

Can this be done, perhaps by having the new file reference
its macro from another text file?

Thanks
Randy
 
D

Dave Peterson

The way you rename a workbook from inside excel is file|SaveAs. Maybe just
showing how to do that would be sufficient.

(Or even closing the workbook and renaming from Windows|Explorer)
 
Top