Import Error Trapping

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?
 
K

Ken Snell

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.
 
C

Craig

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?
 
K

Ken Snell

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.
 
Top