| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing if file is open
Andrew,
Try something like On Error Resume Next Workbooks("BookName.xls").Close savechanges:= True ' or false On Error Goto 0 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "andreww" wrote in message ... Hi - Does anyone know of any code that will check if an xls is open, and if it is, close it? Regards Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing. do not open. | Excel Worksheet Functions | |||
| Testing for an open file | Excel Programming | |||
| Testing if a file is open | Excel Programming | |||
| Testing for a open worksheet from Outlook | Excel Programming | |||
| Testing for open workbook | Excel Programming | |||
Hybrid Mode
