Power Query - running from VBA

Good Day to all

Can I control Power Query by means of VBA? for instance I have a number of queries and on a weekly basis I want to edit the queries to change the date filters and then refresh the resultant tables for the new data?

I have tried to record a macro, but this does not recognize power query editor at all.

No. What you can do is use parameters for your dates so that they can be updated in Excel cells, then just refresh: https://accessanalytic.com.au/powerq...ls_parameters/

Hi rorya

Thank you very much this will make life much easier.