Accessing other applications

[David G]

Hi,

I'm interested in using Excel to link to a web site and using Excel VBA to
download data from these sites to my Excel Workbook for subsequent analysis.
I would welcome any suggestions, maybe there is a website who has published
this kind of code. Any help would be appreciated.

 

[Mike H]

Hi,

try this.

In internet explorer navigate to the web page that contains the data you
want and copy the link.
Select a cell on your sheet where you want the data table to start and then
Data|Import external data|New Web query
Paste the copied link into the address bar and click GO
I used this on
http://newsvote.bbc.co.uk/1/shared/fds/hi/business/market_data/overview/default.stm
Any table you can donwnlink has a yellow arrow. Click one and it turns green
Click import and your table is imported into the worksheet.
Right click the table and you can adjust things like the refresh frequency.

Mike