Getting data from web site to excel

  • Thread starter Thread starter Dusan
  • Start date Start date
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
 
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
(e-mail address removed)
 
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
 
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
 
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++
 
Back
Top