Running an Access Macro from Excel

Hi guys!

I know it’s pretty easy to run a standard Access query/ macro from Excel. But what if I want an Access query to filter on a value from Excel cell (s)? For example I want to be able to list Customer Names in Excel Range (“A1”).Cells and have it run Access Macro so “Customer” field in Access queries filter on Excel Range (“A1”).Cells values? Is this possible? If it is, can wild characters like * be used?
I am posting this in Excel part of the forum because I am hoping to come up with a Code from Excel side, but if it easier to start it from the Access side, where Access finds Excel file and gets the values from there, I would very appreciate help too.

Thanks a lot for any advice!

Hi Marvin,
My ultimate goal is to create a code that would run multiple reports.
For example I listed Customers ABC, DEF, GHI in Range (“A1:A3”), and Customers BAC, FED, HIG in Range (“B1:B3”), I want an Access Macro ran for those listed in (“A1:A3”), then the output damped into Excel, Excel macros would kick in and do the formatting, file saved and then the same thing repeated for those listed in (“B1:B3”), and so on… I’ve learned a little of VBA (with a huge help of this forum), so I am capable of handling transferring the data from Access to Excel to a template, creating and activating formatting /save as Excel Macros, I am having hard time with figuring out how to approach this problem conceptually.
If I link the table as you advised, should I then write a macro that updates the linked table with the new data from “the data input file” and refreshes the link for each separate set of customers I need to run? Would that be a decent approach? What if I need multiple filtered fields (Let’s say “Customers” and “Ship to States”), will that approach handle multiple tables?
Once again, thanks for your time!