View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nate Oliver[_3_] Nate Oliver[_3_] is offline
external usenet poster
 
Posts: 71
Default Web Query with a twist

Hello,

There might be another, perhaps more straightforward, way to do this, but
you might able to control IE with automation. Here's an example of logging
into a website:

http://mrexcel.com/board2/viewtopic.php?t=101460

The last post in that thread tells you the library references you're working
with at this point in the event you prefer to use an early bind.

You'd need to look at the html source code to determine the controls you
want to manipulate.

And here are a couple of examples of 'scraping text' from an html document
http://groups-beta.google.com/group/...6f43d5aba9353d
http://www.mrexcel.com/board2/viewtopic.php?t=75432

Since you already have control of the object, no need to use GetObject, work
with 'ie' like in the 2nd example.

Regards,
Nate Oliver