Import Error Trapping

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am importing data using a macro. When errors occur while importing, a
table of errors gets created.

How can I "Trap" or "test" for an error when importing using a macro and
display it to the user?

Should I test for the existence of the errors table or what, if so how do I
do that?
 
When using a macro? You can't.

You'd have to write VBA code that will open and read each line of data and
test each field so that you could inform the user of any problems during the
import.
 
Can I test for the existence of the errors table?
Or do I just have to tell the user to look for the errors table?
 
Not directly in a macro. You can create a VBA function that will do the test
for you, and then call the function (RunCode) from the macro.
 
Back
Top