thank you...

here's what i've done with mapquest...to take an address, city and state from three cells and find on mapuest...

(i would like to do the same with googleEarth...)


'mapquest
Dim mycity
Dim mystate
Dim sURL As String

myaddress = Range("a2").Text
mycity = Range("a3").Text
mystate = Range("a4").Text

'myaddress2 = Me!address2
'mytotaladdress = myaddress + myaddress2

'sURL = "http://www.mapquest.com/maps/map.adp?city=" + mycity + "&state=" + mystate + "&address=" + myaddress + "&zoom=5"
sURL = "http://www.mapquest.com/maps/map.adp?city=" + mycity + "&state=" + mystate + "&address=" + myaddress + "&zoom=5"
With ActiveSheet

.Hyperlinks.Add .Range("B2"), sURL, , "MapQuest", "MapQuest"

.Hyperlinks(.Hyperlinks.Count).Follow

.Hyperlinks(.Hyperlinks.Count).Delete

.Range("b2") = ""

End With