I currently have a macro which is run nightly via a windows scheduled task, the macro imports a couple of text files and makes various updates based upon the new text files. Currently the macro contains about 53 steps, most of which are running action queries.
I would like to convert the macro over to VB and add some type of error recovery; I am not sure how to go about adding the error recovery?
I thought about first making copies of the tables then on error restoring the tables, then sending an alert email. Any suggestions would be appreciated
I would like to convert the macro over to VB and add some type of error recovery; I am not sure how to go about adding the error recovery?
I thought about first making copies of the tables then on error restoring the tables, then sending an alert email. Any suggestions would be appreciated
