hyperlink

[Guest]

How can I get (http://kevdb.infospace.com/home/whi...ils.htm&QN=reyes&QF=oscar&QC=plainfield&QS=il) the last name first name and city to fill in automatically. in this example it is reyes, oscar,plainfield. I have a field in exl for each.

 

[Don Guillett]

You didn't say how you wanted to do this but this works. XL2002

Sub getname()
'cell b2=first name
'cell c2=last name
mylink = "http://www.people-data.com" & _
"/query1.php?&se=IT&ref=banneri&first=" _
& [c2] & "&last=" & [b2] & "&state=&submit=Search"
ActiveWorkbook.FollowHyperlink Address:=mylink
End Sub
--
Don Guillett
SalesAid Software
(e-mail address removed)

How can I get

(http://kevdb.infospace.com/home/white-pages/kevdb?showrec=34671874:res-us&O
TMPL=/white-pages/details.htm&QN=reyes&QF=oscar&QC=plainfield&QS=il) the
last name first name and city to fill in automatically. in this example it
is reyes, oscar,plainfield. I have a field in exl for each.