View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick LEBON Patrick LEBON is offline
external usenet poster
 
Posts: 3
Default 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