View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zkythen Zkythen is offline
external usenet poster
 
Posts: 1
Default 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?