Searching online behind the scenes
 

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?

Searching online behind the scenes
 

On Dec 31, 10:30 am, Zkythen
wrote:
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.