Change the CSV source in power query

[Omer_K]

Hello everyone,
I have a Power Query that pulls the data from a CSV file
I would like to know how to create a VBA code that when I run it will open a window of changing the CSV file (including refreshing the data) ..
Suppose my query name is TEST

Thank you

 

[Omer_K]

Any One?
I think this post should be in Excel Questions
Because I need VBA code

 

[alansidman]

Are you suggesting that you wish to have the ability to create a different path to the Query? If that is the case, then VBA is not required. This can be accomplished by creating a parameter query and attaching it to your query. If so, then look at this-->Create Dynamic File Path in Power Query - Goodly

 

[Omer_K]

I probably did not explain myself correctly ..
I would like to know that if I click on a button (Probably the button linked to a VBA command) and it will open me 'open window' and I can change the CSV file,
ANy Ideas?

 

[Alex Blakenburg]

See if this helps, Celia Alves goes the next step by writing some VBA to run a File Picker.