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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force macros refer to ActiveWorkbook 2
How to Create a Macro to Import External Data 0
VBA - retrieve data on last create named range from previous inserted named range 0
Worksheet Names using Macros 5
Macro recorded... tabs & file names changed, macro hangs 3
Excel Excel down arrow macro problem 1
Excel 2003 - A macro to exit excel 1
Opening Files - Macro 1

Back
Top