Possible to change the file name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,
Is it possible to change the name of the workbook with vb? The user can
then opt to save the file as the new name when the close the file. I need
the file name change due to the file being email out. Thank you,
Mike
 
No - the only way to change the name is to save the file with the new name.
You can do a savecopyas to make copy of workbook. Email the copy and then
delete it.
 
You must log in or register to reply here.

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

Opening a list of Excel files and run a macro in each 17
How can I migrate MBOX to PST? 2
Change link-source on file after copy the sheet into new a newworkbook 5
VBA - retrieve data on last create named range from previous inserted named range 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help in changing code to see new file name (Dave Peterson) 3
How to change a sheet name without opening the workbook 3
Help with Workbook name change on update 1

Back
Top