File in Use - How to get the user ??!? 
Author Message
 File in Use - How to get the user ??!?


in Excel VBA, how can i know who is the user that has open
workbook ? UserStatus nothing...
But when I open "normaly" the file, the Excel displays a
warning: File In Use ... by "someone"...
How can i grab that "someone" in VBA ??

Have i to use the FindWindow API function and so on...

I'm using Office 2000 Excel 2000 Windows 2000 Professional.
(in a Win2000 Server)

Thanks in advance.


Sat, 26 Mar 2005 23:16:54 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Getting the User Group name using Current User Function

2. Getting file info using a file list box and putting in an array

3. Getting a Domain for a User using their UserId

4. Getting a Domain for a User using their UserId

5. SHFileOperation - getting user cancellation, other options in file overwrite

6. Getting User Name who Created File?

7. Getting full list of Domain Users is not working properly - some users missing

8. Getting the space used by a folder and files contained

9. Getting a File Version using VBScript

10. Getting a detailed directory listing using Internet transfer control, file sizes

11. getting File size using internet transfer control...

12. Getting File Properties Using API


Powered by phpBB® Forum Software