I have an application that begins with data entered into Excel. Several macros are run on the data and then it is brought into Access, where several queries are run to finally get the data where and how I want it.

It would be nice if one macro in Excel could call and run each of the excel macros and then run the Access queries,
OR
a single procedure in Access could call up and run the Excel macros and then the Access queries.

I do not know how to do that or which program does a better job of it. Anyone done this?

What are you trying to do with the data? Do you need to run the macros in Excel, or can Access do any of the processing of the data before it is queried? My preference is to pull the raw data from Excel and then do all the processing in Access.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

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.

To make your life easier, I would follow MMcDonal's advice and do all processing in Access. The same macros that massage the data in Excel can be formulated in Access and probably with greater ease. Just bring in the raw data.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Again, I fully understand the advantages of using Access for all aspects of this. That is NOT an option. NOT.

I appreciate the attempt to give good advice, but I am hoping for a response to the question I asked.

Robert