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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,114,328
Messages
5,547,278
Members
410,783
Latest member
sonnny
Top