Can I use XML instead of an Excel Web Query?
 

Hi Dave F.,

You can use the XMLHTTP object to "screen scrape" a page and then parse out
the HTML response from there. Here's an example from a previous post that
should get you started:

http://groups.google.com/groups?hl=e...GP09.phx.gb l

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Dave F. wrote:
Hi
I'm a newbie to XML

The attatched text file is the source for a web page that I download
info from,using Excel's web query, into an Excel spreadsheet with via
a VBA routine. It retrieves a couple of tables from the page & places
them in the spreadsheet.

I don't really want to put the whole of the tables in my spreadsheet,
I just need a few values from them to do some calcs on them.

Is it possible with XML to extract just the info I require?

If so, do you have any pointers how I'd go about it?

If not, is there another way to do it?

Thanks in advance

Dave F.