Changing Source in Power Query using vba

[ashsweety]

I am newbie to vba. I need to change the source in power query. I have a folder which contains all the data files monthly. I want to select each file one after another use it as source for power query , run the query and save it to worksheet.
e,g Data is for each month. Need to run the query for each month, select source as each month from data folder , run the query and save the data to year table

 

[JEC]

Use a parameter table in power query to which you refer in the source step of your query. You can change the parameter table to a specific path(where the month is variable), then refresh All