Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to tell Who Opened Excel File.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help in saving an excel file opened in IE | Excel Discussion (Misc queries) | |||
Excel file not viewable when opened | Excel Discussion (Misc queries) | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
convert a .dat file opened in Word to excel? | New Users to Excel | |||
Why does my .csv file not appear when opened in Excel? | Excel Discussion (Misc queries) |