View Single Post
  #3 (permalink)  
Old June 10th, 2009, 12:22 PM
rmccafferty rmccafferty is offline
Authorized User
Points: 110, Level: 2
Points: 110, Level: 2 Points: 110, Level: 2 Points: 110, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote