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?
|