Opening an Access Database and running procedure Via Excel VBA
 

I have an access database that has several tables contained withn, a series
of delete and append queries require running on the data before it is
suitable for analysis and retrieval into excel. I have coded the ADO
retrieval from the database, and this is working fine. I have also coded the
delete routines to run from Excel, but I can't get the INSERT sql statements
to work, they through out messages regarding the subquery that is a union
query.

I think my options are to either run the saved queries in the access
database via ADo, or somehow either run a Access macro or VBA procedure to
run these queries. I have coded in Access a simple VBA routine that runs the
queries in the correct order.

Can anybody tell me how I can get Excel to run the VBA procedure in my
database, or alternatively how I can run the append queries via ADO?

thanks,
Paul