what would the code be to check if a file is open and/or exists ? thanks in advance mark
M Mark Kubicki Dec 4, 2003 #1 what would the code be to check if a file is open and/or exists ? thanks in advance mark
T Tom Ogilvy Dec 4, 2003 #2 if dir("C:\Myfolder\myfile.xls") = "" then 'doesn't exist End if 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
if dir("C:\Myfolder\myfile.xls") = "" then 'doesn't exist End if 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
