Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking file already open status
Another user has a tab delimited text file named myFile.xls open on a
server, writing to the file with Labview, and periodically flushing to disk. While he still has the file open, I open the same file in excel using workbooks.open, with ReadOnly:= true. The Labview user tells me this freezes the file so that he can no longer write to it. How can I avoid having Excel open for exclusive use, even though it is read only, and already open by someone else? If I can't do that, then how can I check the status of the file to make sure that no one has it open before I try to open it? John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional adding by checking status | Excel Discussion (Misc queries) | |||
Checking Protect status | Excel Programming | |||
Check file open status | Excel Programming | |||
Checking for an open file in Excel | Excel Programming | |||
VBA Excel Checking whether an XL file is already open elsewhere | Excel Programming |