Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to know if there is a way to catch a specific error. I allow
users to conditionally select files by checking boxs on a userform. If the file doens't exist I would like to process the program as if the box was not checked. The problem I'm having is not knowing which file is missing so I don't know what part of the program to skip. For example: Run-tim error '1004': 'filesname.CSV' COULD NOT BE FOUND. CHECK THE SPELLING OF THE FILE NAME, AND VERIFY THAT THE FILE LOCATION IS CORRECT. If filename.csv is missing I would like to skip the code that processes the data in filename.csv. I could handle it with a bunch of error routines but I would rather find out if I can extract the name of the missing file from the error. Thanks in advance for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Trapping | Excel Discussion (Misc queries) | |||
error trapping | Excel Programming | |||
Error Trapping | Excel Programming | |||
Error Trapping | Excel Programming | |||
Error Trapping | Excel Programming |