Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check if workbook open?
Thanks for any help.
I have a macro (Excel 2000) in a workbook that copies and pastes some tabs into the workbook it opens. But sometimes the files that it opens are already open by another user. In that case, there is an error message and some other stuff can happen that messes up the program. I would like to stop this, is there any properties or code that I can do to tell if a file is already open? I thought of using an On Error stuff, but is there another way? Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to check is someone else has a workbook open | Excel Discussion (Misc queries) | |||
If Then to check if a workbook is open | Excel Discussion (Misc queries) | |||
Check if workbook open | Excel Discussion (Misc queries) | |||
Check for open workbook | Excel Programming |