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!
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!