Getting data from web site to excel

D

Dusan

Hello,

Is there any way to copy some number/variable from web page? Something like
checking and recording certain value
on the web page to excel spread sheet.
I must be easy but I just don't know it.

It there any difference if the web page is html/php/asp ... type?


Cheers
dusan
 
N

Nick Hodge

Dusan

In latter versions of XL (2000 up) you can go to Data>Get External
Data>Create New Web Query. Once set the query is saved with the workbook by
default and you can simply press the requery button.

For a code solution, start by recording yourself doing the actions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
D

Dusan

Thanks Nick,
I knew it must be easy but did not expect to be that easy ... It's shame I
did not find out by myself ...

Cheers
Dusan
 
K

Keith

Yes it is possible and it doesn't matter the extension.
They still send back HTML. Using the web query is the
easiest way. I have a program that gets lots of past
stock data. www.kjtfs.com in the downloads section and
it is called StockDataGetter. The tricky part is
learning the websites web addy scheme.

Keith
www.kjtfs.com
 
P

Patrick LEBON

First thing first, whatever the technique behind the web site the http protocol
will return html.

In XL you can get some data from a web page (Data => Get external data => New
web query). As soon as you run yr query you should spot the value you want in a
cell.

I would recommend you to be very careful since the layout of the web page can
change regularly and you can not control that event!

Good luck,

P++
 
Top