How to get Live data from a web_page

Hoang · April 9th, 2008, 09:52 AM

Hi All!

Please help me to get Live Prices (Spot Gold, bid, ask) from this page "http://www.igmarkets.co.uk/"

Many thanks

Regard,
NCHoang

tstav · April 9th, 2008, 03:01 PM

Wrox Excel 2003 VBA: Programmer's Reference
Pages 603-605: 'Parsing Web Pages for Specific Information'
-----------------------------------------------------------
This is just to get you started. Web querying cannot be covered with just one or two general-idea answers to a general-idea question.
Do you have any code to show? It would be preferable if the code was yours, so that you can explain what you're trying to do.

Shasur · April 10th, 2008, 03:32 AM

If they are in a Table format you can use QueryTables and extract the data.

The code will be similar to normal datasource, with Web URL being a notable difference

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)