| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code to open a workbook only when closed
How can I check in a macro subroutine if the status of another file is open
or close. I would like to open another file only when it is not open. Otherwise, Workbooks.Open Filename:="myfile.xls" simply returns an error when the file is already open while the macro is running. Thanks a lot in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
| I want a macro that can open a worksheet in a closed workbook | Excel Programming | |||
| Open a closed workbook with VBA | Excel Programming | |||
| How: open a workbook with auto macro disabled using code? | Excel Programming | |||
Threaded Mode
