Detect if a file is in use or being modified
 

Anyone know of a formula or vba script to detect if a file is currentl
being modified or accessed by another user?

--
shaw
-----------------------------------------------------------------------
shawb's Profile: http://www.excelforum.com/member.php...fo&userid=1420
View this thread: http://www.excelforum.com/showthread.php?threadid=38275

Detect if a file is in use or being modified
 

Simple VBA test:

From excel, open the file with VBA workbooks.open() with notify =
false. After that check if the workbook has been loaded, if not, the
file is in use.

DM Unseen

Detect if a file is in use or being modified
 

shawb,
Try to Open it Exclusively.

NickHK

"shawb" wrote in
message ...

Anyone know of a formula or vba script to detect if a file is currently
being modified or accessed by another user??


--
shawb
------------------------------------------------------------------------
shawb's Profile:
http://www.excelforum.com/member.php...o&userid=14204
View this thread: http://www.excelforum.com/showthread...hreadid=382751

Detect if a file is in use or being modified
 

http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

--
Regards,
Tom Ogilvy


"shawb" wrote in
message ...

Anyone know of a formula or vba script to detect if a file is currently
being modified or accessed by another user??


--
shawb
------------------------------------------------------------------------
shawb's Profile:
http://www.excelforum.com/member.php...o&userid=14204
View this thread: http://www.excelforum.com/showthread...hreadid=382751