I always prefer to use Access over Excel. But that is not an option in this case. I need to run several macros in Excel, then run a saved import in Access followed by an append query and then a final macro in Excel.
The first two macros in excel massage the data for various reasons, the final one in Excel moves specified records to a Archive tab.
Thus, I need to run events in each program, on after another, and want to make it easy for the user by tying them all into one button, preferable in Access.
|