Getting data from web site to excel
 

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

Getting data from web site to excel
 

Dusan

In latter versions of XL (2000 up) you can go to DataGet External
DataCreate 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
HIS



Dusan wrote:
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

Getting data from web site to excel
 

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



"Nick Hodge" wrote in message
...
Dusan

In latter versions of XL (2000 up) you can go to DataGet External
DataCreate 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
HIS



Dusan wrote:
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

Getting data from web site to excel
 

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

-----Original Message-----
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



.

Getting data from web site to excel
 

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++




Dusan wrote:

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