Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting open files
Thanks, Tom! This is precisely what i needed.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not detecting Open Workbook - Why | Excel Discussion (Misc queries) | |||
Not Detecting Open Workbook Status - Odd?? | Excel Discussion (Misc queries) | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Detecting if a Window/Workbook is Open | Excel Discussion (Misc queries) | |||
Detecting non-supported files using Excel.Open | Excel Programming |