How to tell Who Opened Excel File.
Harald Staff wrote:
Hi
Only way I know is to open read-only and read the WriteReservedBy property. This may or
may not work, depending on the network architecture or something like that.
--
HTH. Best wishes Harald
Followup to newsgroup only please.
"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.
I have tried this experiment on one of my own spreadsheets... Open it
with Notepad and in the first 2-3 lines of garble will have the name of
the last person to access the file. This may not answer your question,
or be technically accurate but it is interesting if nothing else.
Mike
|