Refreshing queries without opening them

[trialpayjinn]

How to refresh and save the quries without opening all of them. Currently, I have to open each query and save them. And these queries are linked to an excel file.



I am looking for a way to refresh about 15 queries (in certain order) via macro (in Access) perhaps

Thank you!

[TheShabz]

what do you mean by refresh? I'm a bit confused.

[trialpayjinn]

I meant RUN...after the new data is appened to the tables from which the queries are pulling data.

Thank you!!

[TheShabz]

create a macro and use the OpenQuery Action. Just list them all one after another. Start and end with the Setwarnings and you should be good to go.