RE: Find out WHO has a file opened for editing

One very reliable way to do this is:

1. Ensure the file is stored on a windows file server in the same place
each time.
2. have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/fs/file_management_functions.asp
3. Specifically you need to use the NetFileEnum function to list the open
files on the server and NetFileClose api function if you want to remotely
close them

Old timers(!) may recall that the old FileManager tool allowed you to do
this on a Windows server - perhaps there is something similar in modern
Windows server software?

I have written the code to do this but I do not have access to that source
safe right now, but this may be of help in the meantime.

Note that the use of the win32 api is not without risk - it's a very
powerful thing that does not have all of the safety built into vb6. Best to
test on a non-production environment.


--
www.alignment-systems.com


"Mike K" wrote:

> Oh Wise Ones,
> We have a shared time*** that someone has open. It is
> reporting a generic user name. Can Excel programmatically return more
> specific information about spefically who has a work*** open, like station
> id or network logon name?
>
> Thanks,
> Mike
.