Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Excel Checking whether an XL file is already open elsewhere
I am trying to write a sub routine when checks to see if
an excel spreadsheet is already opened by someone else on the network. Basically, I need to update a "summary" spreadsheet with data ... but it is often open and being view by others .. so i need to check if it is indeed being read and halt the update. hope someone can help thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Using wildcard for checking whether files are open | Excel Programming |