vba to change power query data source folder

**Undo** · 01-22-2021, 06:00 AM

Hey

I need to change folder source from this button

1.png

rather than I open the power query setting and click change source

2.png

Thanks

**rorya** · 01-22-2021, 07:20 AM

It's easier to just set up a parameter table with the folder path in it, as in the attached version of your file.

**Undo** · 01-22-2021, 04:13 PM

Thank you!
But can u explain how I can do that? only I give the cell name ParameterTable ? Then how I connect it with the PowerQuery Table?

**rorya** · 01-22-2021, 04:28 PM

Look at the change I made to the first step of your query.

**Undo** · 01-22-2021, 04:38 PM

I see but I dont knpw how to do it

**rorya** · 01-22-2021, 04:41 PM

You just need a table called Parameter Table set up like I did in your sample file.

**alansidman** · 01-22-2021, 06:53 PM

This video may help to understand what Rory is referring to.

https://www.youtube.com/watch?v=LHNVkiGlUbE

**Bo_Ry** · 01-22-2021, 11:29 PM

1. Create a new range name

fPaht
='New folder'!$E$1

2. Power Query to get folder path from range name

Please Login or Register  to view this content.

3. VBA to put folder path at E1 and refresh all query

Please Login or Register  to view this content.

Re: vba to change power query data source folder