I have a scripts library doing report generation based on information from a Excel file.
But I want to make sure that the Excel file is in the user's local drive before I proceed to generate the reports.
I get this following error message if the Excel file is not in the local drive:
"C:\mcs_data.xls" could not be found. Check the spelling of the file name. and verify that the file location is correct.
If you are trying to open the file from the list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.
Anybody knows how to skip this error message and proceed to the rest of coding, if the file is not found?
Pls help me if you knows, it's quite urgent to me....
Thanks a lot.