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
R Avery wrote in message
...
Is there any way to programmatically (from Excel) determine whether or not
there are any instances of Word or Acrobat or some other program that has
a
particular file open? Or, is there a way to determine whether or not a
file
is currently in use by knowing only its path? Thanks!