Support and Answers >> Google Earth (read only) Previous   Index   Next   Flat

mjschukas Tourist Reged: 11/29/05 Posts: 9 Re: open googleEarth from excel...       12/30/05 07:06 PM Edit   Reply   Quote   Quick Reply   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 Post Extras

Entire topic Subject Posted by Posted on open googleEarth from excel... mjschukas 11/29/05 11:23 AM Re: open googleEarth from excel... Periboob   11/29/05 08:22 PM Re: open googleEarth from excel... mjschukas   11/29/05 09:21 PM Re: open googleEarth from excel... Periboob   11/29/05 10:04 PM Re: open googleEarth from excel... mjschukas   11/30/05 03:22 PM Re: open googleEarth from excel... mjschukas   12/30/05 07:06 PM Re: open googleEarth from excel... hangglide   05/30/06 12:34 PM Re: open googleEarth from excel... barryhunter   05/30/06 04:07 PM Re: open googleEarth from excel... mjschukas   07/05/06 01:12 PM Re: open googleEarth from excel... crvrij   12/01/05 06:38 PM Re: open googleEarth from excel... mjschukas   07/06/06 08:13 PM

UBB.threads™ 6.5.1.1