Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to close a workbook which contains the macro that's just been run?
Hi Ryan, Thank you kindly for your reply. That extra bit of code (in red) was added after creating my initia macro, which was running without error until the extra code was added. Hence, I believe it is that extra bit of code (in red for closing th workbook) that is the cause of the error message. In any case, he way I've done it seems to be a bit cumbersome: 1. I select the workbook which contains the macro and make it th active workbook Workbooks("Replace_All Names.xls").Activate 2. Then close the active workbook (ie. the workbook which contains th macro that I've made the active workbook by step 1.) ActiveWorkbook.Close Are there any other elegant ways of doing this simple task -- dead_gir ----------------------------------------------------------------------- dead_girl's Profile: http://www.excelforum.com/member.php...fo&userid=1559 View this thread: http://www.excelforum.com/showthread.php?threadid=27145 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Close a specific workbook. | Excel Discussion (Misc queries) | |||
Macro to close workbook with prompt | Excel Worksheet Functions | |||
run macro on workbook close | Excel Discussion (Misc queries) | |||
How to close a workbook which contains the macro that's just been run? | Excel Programming | |||
Close Workbook from Macro | Excel Programming |