| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check if file is already open
Hi,
I want a macro to check is a file, which is called upon, is already open and if so skips the opening line of the code and proceeds with the rest, otherwise proceed with opening the file. Currently Excel asks me if I want to reopen the file and unsaved data will be lost. Cheers, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then to check if a workbook is open | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| how do i check an open files size? | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| Check if workbook open | Excel Discussion (Misc queries) | |||
Threaded Mode
