Detecting open files

[R Avery]

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!

 

[Tom Ogilvy]

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

 

[R Avery]

Thanks, Tom! This is precisely what i needed.