Error/Result trapping when using TransferText in a Macro

G

greyhound girl

I am using a macro to perform a couple of data imports and need a way to tell
the user when the import is not successful for various reasons. I am using
the TransferText action for the import and would like to use a conditional
with the MSGBOX action to display the result of the import. Can this be done
with a variety of "error" code values? If so, where can I find a list of the
"error" code values?
 

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

Macro Loop 0
macro action "TransferText" Add primary key 5
Working outlook via vba code with xlsx - error 0
Error When Using TransferText in a Macro 1
Macro to transfertext giving error msg 4
Import text file with macro - Invalid argument (Error3001) 0
I can't specify the Specification Name when use transfertext 1
Need Help with Macro Security 1

Top