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
|