Hi Don and thank you for your answer.

The table is located on the following web page:

http://www.taloussanomat.fi/sivu.php...ge=bas icdata

The figure I need is in the table named "Kaupat". It is the first figure in
the column "Hinta".

Couold you describe how I can access this information with a function and
use it in calculations?

Thanks.



--
Melwin


"Don Guillett" wrote:


You didn't post any of your attempts or url(s). One way to do this is with
an external query. Place your cursor in the table you want to fetchright
clickimport to excel. dataexternal query
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Melwin" wrote in message
...
Hi,

Does anyone know any good tutorials for web queries using VBA? I need to
retrieve data from a table located on a website (not whole table). How
should
I write the query? What is the basic structure of a web query?

The query will be part of a public function where i use one input that
will
be part of the website url from which the data is retrieved. The function
output will be a number in double format.

If someone has some simple VBA code for this, please send it to me.

Thanks
--
Melwin