create macro when creating file

[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

 

[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)