How to change source of a power query using VBA?
<p>So in Excel 2016, they have this neat tool called Power Query, basically a glorified excel table. Every table has steps in it for filtering, removing columns, etc... The first step is the source step, to assign a connection string basically to retrieve data, normally this source just points back to the query which created it. </p>

<p>Anyways, I'm trying in VBA to dynamically change the source of these power queries, anyone have any ideas? </p>

<p>I tried using the whole connections vibe, but was unsuccessful.</p>