Hi Michael,

You are welcom and glad it helps!

Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

"Michael Bond" wrote in message
...
Harald, Colo

I've combined both solutions and now have a text file
which logs everyone's use of the file (useful for
historical checking on who is accessing the file), and a
separate log file which shows who the current "read/write"
user is (includes username, computer name and date/time
opened). The log file is killed when the main file is
closed. My update application checks for the existence of
the log file. If not there it opens the file and runs my
update. If it is there it starts another sub which loops
at time intervals checking for the existance of the
file...and pops up a message when the file becomes
free....if the file stays open too long I can now contact
the user and ask them to close it....your idea has proved
most useful...I'm glad I asked.

Thanks and regards

Michael Bond

-----Original Message-----
Good morning

I have a workbook located on a network directory to which
many users have access.

I am writing additional code to update that wokbook from
time to time.

I want to be able to tell, before any action is taken, if
anyone already has the workbook open, either "read only"
or "read/write"

Is is possisble to do this....and if so can the user who
has it open "read/write" be identified.

The file is not shared.

Using Win2000 and Excel2000

Thanks and regards

Michael Bond

.