Hey all,
I've got an excel issue I'd like some help with. I've been mapping out some lakes and their respective coordinates with google earth. Sometimes I need to make new coordinates because their old coordinates were wrong--I need to change a LOT of stuff and need an easier way to do so. Regardless of the context, I have a situation where I have this:
Column A - Lake Name
Column B - Longitude of Lake
Column C - Latitude of Lake
Column D - Really long xml code found below. I need the bolded part below to replace B & C above.
"<?xml version=""1.0"" encoding=""UTF-8""?>
<kml xmlns=""http://www.opengis.net/kml/2.2"" xmlns:gx=""http://www.google.com/kml/ext/2.2"" xmlns:kml=""http://www.opengis.net/kml/2.2"" xmlns:atom=""http://www.w3.org/2005/Atom"">
<Document>
<name>KmlFile</name>
<Style id=""sn_ylw-pushpin"">
<IconStyle>
<scale>1.1</scale>
<Icon>
<href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>
</Icon>
<hotSpot x=""20"" y=""2"" xunits=""pixels"" yunits=""pixels""/>
</IconStyle>
</Style>
<StyleMap id=""msn_ylw-pushpin"">
<Pair>
<key>normal</key>
<styleUrl>#sn_ylw-pushpin</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#sh_ylw-pushpin</styleUrl>
</Pair>
</StyleMap>
<Style id=""sh_ylw-pushpin"">
<IconStyle>
<scale>1.3</scale>
<Icon>
<href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>
</Icon>
<hotSpot x=""20"" y=""2"" xunits=""pixels"" yunits=""pixels""/>
</IconStyle>
</Style>
<Placemark>
<name>Untitled Placemark</name>
<LookAt>
<longitude>-71.62791402659985</longitude>
<latitude>41.69594132714693</latitude>
<altitude>0</altitude>
<heading>0.07945165186458728</heading>
<tilt>0</tilt>
<range>7452.521349966087</range>
<altitudeMode>relativeToGround</altitudeMode>
<gx:altitudeMode>relativeToSeaFloor</gx:altitudeMode>
</LookAt>
<styleUrl>#msn_ylw-pushpin</styleUrl>
<Point>
<altitudeMode>absolute</altitudeMode>
<coordinates>-71.60704512966066,41.69591783028302, 125.114287591884</coordinates>
</Point>
</Placemark>
</Document>
</kml>
"
Does anybody have an idea as to the function that will automatically replace B & C with the two coordinates found bolded in the google earth xml code?
Thanks
Bookmarks