Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

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.
0
jmyrtice
Asked:
jmyrtice
  • 5
  • 5
  • 2
1 Solution
 
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
 
jmyrticeAuthor Commented:
Under find a person
Last name, first name, state, address
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now