This may be a silly question.
I have queries added to my workbook all from the same URL.
Currently, my code loops through each query and extracts each table one at a time.
So it's connecting to the URL several times to get all of the tables.
I was wondering if there was a way for me to extract all of the tables with just one connection to the URL.
I'd rather not have to connect to the URL several times just to get the tables that I want.
Here's the code for what I'm currently doing:
Is it possible to import all of this in one go without having to connect more than once?Please Login or Register to view this content.
Thanks.
Bookmarks