I am looking to download data from web site. From what I have read, it is quicker to take the data into a query table and then select data from a specified table. How can I either dispaly the tables on a worksheet or determine the structure of the web page.
.
My starting point is the Excel2007 VBA Programmers Reference (also the 2003). However, I just do not know how to locate the data I want - looking at the site does not help & grabbing the HTML code does not help me.
.
My starting point is the Excel2007 VBA Programmers Reference (also the 2003). However, I just do not know how to locate the data I want - looking at the site does not help & grabbing the HTML code does not help me.
