Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining who has an Excel file open
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining who has an Excel file open
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-- -- RyGuy "Matthew Pfluger" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining the number of open workbooks | Excel Programming | |||
Determining if a file is open using VBA | Excel Programming | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Determining Whether File Exists | Excel Programming | |||
Determining if Other Workbooks Are Open | Excel Programming |