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 |
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 |
All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com