Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming 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
|
|||
|
|||
Renaming workbook!
Try these site they are loaded with in fo and code!
Simon http://www.cpearson.com/excel http://www.contextures.com/tiptech.htm -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook crashes after renaming a worksheet - References problem? | Excel Programming | |||
Excel VBA: Renaming a workbook | Excel Programming | |||
Renaming Sheets in a workbook | Excel Programming | |||
Renaming Problems | Excel Programming | |||
Renaming within VBA | Excel Programming |