| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if a file exists / is open
what would the code be to check if a file is open and/or exists ?
thanks in advance mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if a file exists / 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 -- Regards, Tom Ogilvy "Mark Kubicki" wrote in message ... what would the code be to check if a file is open and/or exists ? thanks in advance mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check for Open File! | Excel Discussion (Misc queries) | |||
| check if file is already open | Excel Discussion (Misc queries) | |||
| Check if file exists | Excel Discussion (Misc queries) | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| check if worksheet exists | Excel Worksheet Functions | |||
Linear Mode
