I am using Access 2007.
I built a macro using the macro builder to import a spreadsheet file.
It works fine.
Now, I want to alert the user via a message box that the import was successful. How do I determine if there were any errors - even the one you get when it cannot find the xlsx file?
Any help you can give will be appreciated.
I built a macro using the macro builder to import a spreadsheet file.
It works fine.
Now, I want to alert the user via a message box that the import was successful. How do I determine if there were any errors - even the one you get when it cannot find the xlsx file?
Any help you can give will be appreciated.
