Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to change the file name?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to change the file name?
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. -- Regards, Tom Ogilvy "Mike R." wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change a csv extension file to an xls file and use it? | Excel Discussion (Misc queries) | |||
2 users open same file and both can edit/change the file | Excel Discussion (Misc queries) | |||
How do I change *.CSV excel file to column seperated file? | Excel Discussion (Misc queries) | |||
How to change a MS Word file to an Excel file | Excel Worksheet Functions | |||
How do I change file/open/"files of type" to default to "all file. | Excel Discussion (Misc queries) |