| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Errors with Workbooks.OpenText
I've got this line of code:
Workbooks.OpenText FileName:=sFilePath & ".xls", _ DataType:=xlDelimited, Tab:=True The file is opened using the path and filename entered by the user into a form. How can I handle errors so that if the file/path is invalid or the file doesn't exist, it gives an error message rather than falling over? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbooks.Opentext - oldskool '97 | Excel Programming | |||
| Handling Errors and MessageBox | Excel Programming | |||
| Handling errors in formulas (how annoying are they!) | Excel Discussion (Misc queries) | |||
| Workbooks.OpenText | Excel Programming | |||
| Handling Errors from Worksheet Functions | Excel Programming | |||
Threaded Mode
