Reverse phone lookup

[joeKra]

Hello,

I would like to create a reverse phone lookup function to lookup yellow pages etc. based on phone number value i will provide , can some one guide me how to do it, as i am not familiar in web programming

thanks in advance,

 

[JANR]

You can use:

Application.FollowHyperlink URL-string

Here is the one I use as a function in a Standard Module

Public Function sYellowpages(phone As Long)
Const sStr = "http://www.gulesider.no/gs/categoryList.c?q=" 'URL-sting to Yellowpages
    Application.FollowHyperlink sStr & phone
End Function

To call it the function like from a click-event on a form command button I put this in that event.

=sYellowpages([PhoneNumber])

Obviously you need to error trap to prevent sending a NULL to the function, I do this by hiding the button if it is null, but you can wrap the function call with the Nz() function and send a bogous number.

=sYellowpages(Nz([Phonenumber],0))

This is a very simplistic way to do it but it should work IF you got the right URL-String.

Hope this helps

JR

 

[joeKra]

Thanks for reply

i don't want to open the browser i just want to get the values like the name and address and so on..

thanks,