create macro when creating file

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
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)
 
Back
Top