Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to determine the presence of a file using the
DIR command as follows: If Len(Dir(path & wbook)0 Then 'File Found End If However, when the path variable is not available, my macro aborts with the error message "Path not Found". I'd appreciate any suggestions on how I can determine the path is not present before I get the error message. Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Path Not Found Error | Excel Programming | |||
Which Path not found? | Excel Programming |