Searching online behind the scenes

[Zkythen]

I'm useing Excel to create a sort of address book of agents from a website
that gives their informations. I can load a given page and feed information
from it into cells useing Macros, however I don't know how to figure out what
pages I need to load. For example, if I know Bob is page /bob.htm then I can
load it up and get Bob's info. What I need to do is load /search.htm, modify
the properties of the search pulldowns, use the search function to load
/results.asp, then read the list to get that Bob is /bob.htm and Joe is
/joe.htm, then load those respective pages to get their informations. Help?

 

[Rob]

I'm useing Excel to create a sort of address book of agents from a website
that gives their informations. I can load a given page and feed information
from it into cells useing Macros, however I don't know how to figure out what
pages I need to load. For example, if I know Bob is page /bob.htm then I can
load it up and get Bob's info. What I need to do is load /search.htm, modify
the properties of the search pulldowns, use the search function to load
/results.asp, then read the list to get that Bob is /bob.htm and Joe is
/joe.htm, then load those respective pages to get their informations. Help?

Do you have a sample web page? Also, is the html search Post or Get?
You may be able to skip the search process by using a more exact web
address.

 

[Zkythen]

The web address for the results page is "/results.asp", so no, I cannot use
an exact web address. I've asked around other places and it seems this
cannot be accomplished with an excel doc, though we'd all like to know how if
it can.