Detecting open files
 

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!

Detecting open files
 

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!

Detecting open files
 

Thanks, Tom! This is precisely what i needed.