Determining who has an Excel file open

  • Thread starter Thread starter Matthew Pfluger
  • Start date Start date
M

Matthew Pfluger

I maintain an add-in on my company's shared drive, and I want to determine
who has the file open at any given time. I can already determine if the file
is open, but how can I obtain a list of users who are accessing the file?

Thanks,
Matthew Pfluger
 
This is from a post last year (which I just stumbled across...):

http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

the approach is to try to open the file with exclusive access using low
level fileio.


Regards,
Ryan--
 
Back
Top