excel file that read whitepages.com and returns list of address

I have an excel file that has the name, state and sometimes an address.  I need some code in VB that will loop through my file and return matches.
jmyrticeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Patrick MatthewsCommented:
Hi jmyrtice,
> loop through my file and return matches

Matching what to what, exactly?

Regards,

Patrick
0
 
justchat_1Commented:
Matching lookups from whitepages.com?
searching by what field and returning what field?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jmyrticeAuthor Commented:
Under find a person
Last name, first name, state, address
0
 
Patrick MatthewsCommented:
Sorry but you're still not being clear.  Please post some sample data, and describe the search.

Patrick
0
 
jmyrticeAuthor Commented:
Ok when you go to yellowpages.com and click on whitpages.  you can select find a person and it has first name, last name street number state and so on.  I want to take my excel fiel that has this information and return the list of matches to me
0
 
justchat_1Commented:
Replace %firstname%, %lastname%,%cityzip% and %state% with the correct fields from your database...
0
 
jmyrticeAuthor Commented:
I will try this and get back with you
0
 
jmyrticeAuthor Commented:
Well actually i am trying to return missing data sometimes I only have the name state and zip
Although I want this in VB i want to use it in Access
0
 
justchat_1Commented:
Name state and zip is all the data that the site requires...if any of these fields are missing just dont include that part of the url

Example (if there is no first name remove the firstname part):
http://www.whitepages.com/10001/search/FindPerson?name=%lastname%&city_zip=%cityorzip%&state_id=%state%
0
 
jmyrticeAuthor Commented:
I am at a lost I can not seem to put this together could you write the code out please
0
 
justchat_1Commented:
my fault-didnt see the response:
jmyrtice if your still interested I can help you with the code...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.