Hello,

Ah, OK - I would never have thought about it using commas instead of decimal points.

I guess that this is excel 'helpfully' formatting the columns for you. As they are just text strings, you might be able to just change the format of the column - I can't test that easily as mine is set up in a British way. If you find out, let me know and I'll update the post.

Quote:

Next thing ide like to figure out is how to add a choice of icon in your macro. Any suggestions?



Any good at VBA scripting?

You've two options:
  • Open the KML file in GE as it is, right-click on the folder and select Properties > Style and change the Icon for the whole folder
  • Edit the macro and include the KML code for Icons in there

    I probably won't do that because I don't want this thing to become too complicated but it shouldn't be too difficult to work out - you'll need to add some code at the top for a <Style> to reference and a <styleUrl> in the code for each placemark. Have a look at the KML documention for more information:
    http://earth.google.com/kml/

    You could also set a style for a whole folder (described above) and then save that folder as KML and have a look at the code in a text editor - that willl show you the structure you need.



    Simon.