| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Determine if a File Exists
I am using the following code to open a file:
EmployeeListFileName = PathName + "\hourly employees.csv" Set wb = Workbooks.Open(EmployeeListFileName) The user is entered to enter the PathName. I would like to return a message if the file is not found in the specified directory. How do I test whether the file is found? Any help would be appreciated. Thanks! Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| File Exists | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
| Micro that checks if file exists | Excel Worksheet Functions | |||
Threaded Mode
