View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default How to tell Who Opened Excel File.

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.