Check to see if XL file is opened

[KGee]

I need to check if files on a network share are in use or otherwise locked by some process. If the file being checked is in use, I would also like to get the name of the user who has the file open. I've found code that tells me if the files I need are in use but I still need to determine who has them open.

The examples I've found follow the basic syntax below to test if the files are in use:

Open file_in_question For Binary Access Read Write Lock Read Write As #filenum
or
Open file_in_question For Input Lock Read As #filenum

Does anyone have an example they can share that will give me the user name as well?

 

[daverunt]

There's an article here that might help.

http://www.xcelfiles.com/IsFileOpen.html#anchor_37

The Microsoft page for IsFileOpen

http://support.microsoft.com/kb/291295

 

[KGee]

There's an article here that might help.

http://www.xcelfiles.com/IsFileOpen.html#anchor_37

The Microsoft page for IsFileOpen

http://support.microsoft.com/kb/291295

Thanks for the links, these are two that I already found while I was searching. I thought the first link was promising but I received inconsistent results. I tested by opening a few different files and sometimes it showed my name (my full name and not my network login), other times it was blank, and I also received something wierd like "a satisfied MS office user". The "satisfied user" message was when I tried with an Excel file which was output from another program. Which has me thinking if the LastUser property has the information I need to begin with.

Thanks again.