Query Table from Internet page

krissz

Board Regular
Joined
Feb 21, 2010
Messages
95
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.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,108,644
Messages
5,524,046
Members
409,557
Latest member
lgambit

This Week's Hot Topics

Top