Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a named workbook?
Hi all, I have a generated filesearch list of files, in a master workbook (FM Purchase Order.xls). Is there a macro that i can put in the auto_open bit of the searched files, to say: If there is an workbook open called "FM Purchase Order.xls", close it. Thank you! -- drucey ------------------------------------------------------------------------ drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553 View this thread: http://www.excelforum.com/showthread...hreadid=526037 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a named workbook?
Sub test()
On Error Resume Next Workbooks("FM Purchase Order.xls").Close On Error GoTo 0 End Sub HTH -- AP "drucey" a écrit dans le message de ... Hi all, I have a generated filesearch list of files, in a master workbook (FM Purchase Order.xls). Is there a macro that i can put in the auto_open bit of the searched files, to say: If there is an workbook open called "FM Purchase Order.xls", close it. Thank you! -- drucey ------------------------------------------------------------------------ drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553 View this thread: http://www.excelforum.com/showthread...hreadid=526037 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a named workbook?
Artus, you are amazing. -- drucey ------------------------------------------------------------------------ drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553 View this thread: http://www.excelforum.com/showthread...hreadid=526037 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing a workbook | Excel Discussion (Misc queries) | |||
Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
Closing workbook | Excel Programming | |||
closing excel after closing a workbook | Excel Programming | |||
Closing a workbook | Excel Programming |