Once I have created a kml file to show in Google Earth, like the type that I showed you and that you came up with a version of, I may need to do Quality Control and correct mistakes. I am doing this in an MS Excel 97-format spreadsheet. The reason being is that it is compliant with a function in Geomedia—I submit the spreadsheet to the function and it creates the layer that I then export to ESRI’s SHAPEFILE format that I then bring into ArcGIS (see www.esri.com or go to Google and type ‘shapefile” for the basics on this). After I bring it into ArcGIS, I create smaller shapefiles (subsets) from the original shapefile and THEN create KMZ/KML files that I can bring into Google Earth.

When I see mistakes with the KML files in Google Earth, I go back to the MS Excel spreadsheet and make the corrections and then through a function related to how the spreadsheet is in Read-Write format (or other description) and Geomedia fixes the error.

My question for you is whether there is a way to have the error corrections in MS Excel be directly applied to Google Earth? (I could ask about whether the error corrections be applied to ESRI’s shapefile format and then Google Earth but that would be asking too much for now).

One of the things that might or might not help is that the “records” (or segments) in the KMZ file in Google Earth have HTML links in them that allow them to be oriented (or “linked”) to their exact location in Google Earth. Part of this has to do with the fact that the segments have Latitude and Longitude fields.

I have wondered if there is a possibility for the records in MS Excel have an HTML link to the same record in Google Earth—a reciprocal link might be a way of describing it.

Email me directly at [email protected] for attachments (couldn't do that here?)

Dan B