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
|