Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test fileOpen
Hello.
I have a list of several files that i want to open in write mode. It could happen that some of these files are being allready opened in write mode by other users. How can i test if the file is opened exclusively by another user? And if so, is it possible to give a message with the Excel username of that user? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test fileOpen
MS has code here that checks to see if any file is open:
http://support.microsoft.com/default...;EN-US;q138621 XL: Macro Code to Check Whether a File Is Already Open (Q138621) And it's even called "IsFileOpen" Luis wrote: Hello. I have a list of several files that i want to open in write mode. It could happen that some of these files are being allready opened in write mode by other users. How can i test if the file is opened exclusively by another user? And if so, is it possible to give a message with the Excel username of that user? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
test..where are my messages..test | New Users to Excel | |||
Macro to run on fileopen for all workbooks | Excel Programming | |||
Using FileOpen | Excel Programming | |||
Selecting a file path in Excel VBA using FileOpen dialog | Excel Programming |