Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename a workbook!
Hi all!
A quick question.Here is what I am trying to do. Name of the original workbook changed in the middle of certai operations/tasks performed by some macros. So I want to rename th workbook back to the orginal name and at the same time, i DO NOT wan to save the changes made/done in the sheet/workbook till then and kee the workbook still open, so that I can repeat the macros again an again before finally closing the workbook manually. I tried the following but evidently could'nt use it, as it closes th sheet. activeworkbook.close savechanges:=false Any help would be appreciated guys. Thanks. Arun, Vtec Corp -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename a workbook!
There should be no reason to use the name of the workbook.
Use ThisWorkbook to refer to the workbook containing the code. Use ActiveWorkbook to refer to the active workbook. The only way to change the name of a workbook is to save it using that name and Save As. If you save it, you accept all changes (but they are saved in the newly named workbook and the original remains unchanged). -- Regards, Tom Ogilvy "aiyer " wrote in message ... Hi all! A quick question.Here is what I am trying to do. Name of the original workbook changed in the middle of certain operations/tasks performed by some macros. So I want to rename the workbook back to the orginal name and at the same time, i DO NOT want to save the changes made/done in the sheet/workbook till then and keep the workbook still open, so that I can repeat the macros again and again before finally closing the workbook manually. I tried the following but evidently could'nt use it, as it closes the sheet. activeworkbook.close savechanges:=false Any help would be appreciated guys. Thanks. Arun, Vtec Corp. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rename workbook that I am editing without saving? | Excel Discussion (Misc queries) | |||
How to open a new workbook and rename the workbook? | Excel Discussion (Misc queries) | |||
rename a group of spreadsheets in a workbook | Excel Discussion (Misc queries) | |||
How do I loop through workbook and rename all chart titles? | Excel Programming | |||
Workbook, worksheet rename | Excel Programming |