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 |
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 |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com