"You can copy the third line from any Web query [.iqy] file and use it as the URL."
But I can't find any .iqy files on my computer after creating a Get External Data / From Web query that gets a table.
I'm trying to construct vba code that will do the same thing exactly when run.
If I copy the URL from the Connection that's created then instead of getting the table intended, it appears to grab stuff from the entire page.
The table that's grabbed with the Get External Data connection is the table of 7 items in the mid-left part of the page starting with Prev. Close.