Need help with reverse phone lookup

[steve2003]

Hi,

I have a list of phone numbers of various companies that I need the
addresses for. I have about 500 numbers that I need the address, city,
state, and zipcode for. I do not want to manually lookup the numbers by
typing them into a website (such as anywho) manually. I have all of the
phone numbers in excel already. Does anyone know if there is a macro
for formula that will automatically look up the address for a phone
number in excel? Any help would be greatly appreciated and would save
me a bunch of time from manually looking up each number.

Thanks,
Steve B
Boulder, CO

 

[JPW]

You might be able to create a VBA procedure which will run a web query over
and over, depending on which version of Excel you have and how important
this is...

 

[steve2003]

I ended up using a windows-based macro program to copy the phone number
and paste it into anywho, wait a few seconds, and then paste the
retrieved data back into excel. Thanks for the help.


-Steve