How to tell Who Opened Excel File.
Just a thought: if this is your workbook (or at least you have control
over it)and you want to know who is opening it, you could write code
in the Workbook_Open event which captures the user's userID, name, etc
(using Windows APIs) and persist these values somewhere visible to
you. An extension to this idea is to get the workbook to regularly
poll (using the OnTime method) a database, text file on the network,
etc where you can set a value to tell the workbook to close,
effectively throwing out the current user so that you can open the
workbook.
--
"PS" wrote in message ...
Hello,
In a Network Computer, an Excel file is opened by someone (eg. PS)
When I open the Excel file, this message dialog is prompted
---------------------------------------------
aaa.xls is locked for editing by 'PS'
Open ..... ...... ....... ..... ..... ...... ...... in use.
---------------------------------------------
My Question is "Is there any way to extract 'PS' ?"
Maybe API ?
Thanks in advance.
|