Searching Phone Numbers Online
 

I'm looking for some help in creating a program that will allow me to
take a list of phone numbers and have them be searched on the internet
through a site such as www.411.ca etc. returned with a link to the
information about each phone number or the actual information regarding
that phone number, imported into excel. I have been looking at many
articles and I can't seem to find exactly what I am looking for. I'm
not sure if it can be done using excel... Would anyone have any
information for me or any ideas, it would be greatly appreciated.

Dewar

Searching Phone Numbers Online
 

You can goto the correct url and get the info on the screenthen right click
in the tableimport to microsoft exceldataimport external dataedit
queryget the tablesrecord a macro put into a for/each loop.

--
Don Guillett
SalesAid Software

"Fleming" wrote in message
ups.com...
I'm looking for some help in creating a program that will allow me to
take a list of phone numbers and have them be searched on the internet
through a site such as www.411.ca etc. returned with a link to the
information about each phone number or the actual information regarding
that phone number, imported into excel. I have been looking at many
articles and I can't seem to find exactly what I am looking for. I'm
not sure if it can be done using excel... Would anyone have any
information for me or any ideas, it would be greatly appreciated.

Dewar

Searching Phone Numbers Online
 

I would first like to thank you for responding to my post. I am not a
very skilled user when it comes to macros, actually they are new to me,
so I was just wondering if you could give me a little more detail. I
haven't been able to attempt the directions you gave me because my
computer with excel on it is currently down. One thing I was uncertain
about is, how would I go about adding the phone numbers in once I am at
the correct URL, is there a way I can add that cell without having to
actually add the phone number into the URL search box. One other
question, how and where would I create the for/each loop so that the
steps will be followed for all the list of phone numbers, Thus saving
me from searching each phone number one by one through the internet.

Don Guillett wrote:
You can goto the correct url and get the info on the screenthen right click
in the tableimport to microsoft exceldataimport external dataedit
queryget the tablesrecord a macro put into a for/each loop.

--
Don Guillett
SalesAid Software

Searching Phone Numbers Online
 

This is a project but the general idea is to make a list and have the macro
change the last part of the url for each phone number to add the data from
the trip to the web site. Somewhat involved.

for each c in range("mylist")
myrul="xxxxxxxxxxxxxxx"&c
next

--
Don Guillett
SalesAid Software

"Fleming" wrote in message
oups.com...
I would first like to thank you for responding to my post. I am not a
very skilled user when it comes to macros, actually they are new to me,
so I was just wondering if you could give me a little more detail. I
haven't been able to attempt the directions you gave me because my
computer with excel on it is currently down. One thing I was uncertain
about is, how would I go about adding the phone numbers in once I am at
the correct URL, is there a way I can add that cell without having to
actually add the phone number into the URL search box. One other
question, how and where would I create the for/each loop so that the
steps will be followed for all the list of phone numbers, Thus saving
me from searching each phone number one by one through the internet.

Don Guillett wrote:
You can goto the correct url and get the info on the screenthen right
click
in the tableimport to microsoft exceldataimport external dataedit
queryget the tablesrecord a macro put into a for/each loop.

--
Don Guillett
SalesAid Software