"on error" not working

S

sirshannon

I have tried several different On Error ways to trap/hide errors but none of
them are working for a "file not found" error when opening a text file for
input. Not even On Error Resume Next works.

Is there a setting somewhere that I have missed or is the error not
trappable when caused by "Open FileName For Input as #1"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Internal Data Integrity (Type 4) Details Needed 1
I have lost 6 months work, how can i get my file back 1
How to trap Excel Save from Access 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
VBA - exporting serial letters to single documents 0
Visio 2019 crashes when attempting to open drawing. 0

Top