Power Query Connection

Anna_Od

New Member
Joined
Jun 26, 2020
Messages
3
Platform
  1. Windows
Hello everyone!
So I have an Excel file that imports tables from an external file (link to this file is in a list on sheet1) into a new sheet of this workbook.
These imported tables are huge and very hard to work with so I'm trying to import through a Power Query. The table file location may change (hence the list of link), but the tables at those links will keep their format and headers.
I have created the queries needed by connecting directly to the file (by browsing) and not via link on sheet1.
Is there a way in VBA to loop through the list of links, create the link as a variable, and use that link as the data source for the PQ connection?
Thank you in advance!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,114,064
Messages
5,545,782
Members
410,706
Latest member
antstt
Top