Hi quartz,

Thanks again Jake. Is it possible to tweak your code to just get
certain pieces of data rather than the whole file?

I am just looking for certain stock information residing on web
sites...

You could use Instr, Mid, etc. to look for specific elements in the
responsetext. You may be able to work directly with the document using the
DOM (document object model), but I'm not sure of how to integrate that with
the XMLHTTP object.

Another option would be to automate IE (InternetExplorer.Application
object), navigate to a URL, then parse the document as needed by using
Document.GetElementById("elementname") or similar. But that requires that
the HTML elements you need have IDs, which most don't.

Also, where can I find more example code using Stream, and learn more
about what it is for, etc.?

Here's a page that gives a good overview, although it's targeted more to the
web development crowd. You could do a search of MSDN, and you'll probably
find too much info there. <g

http://www.w3schools.com/ado/ado_ref_stream.asp

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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