hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
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)
oscar said:
How can I get
Click to expand...
(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.
 
Back
Top