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

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/