Placemark icon color change in xls2kml 1.16.03 for google earth

[zessawy]

Hi experts,

i'm using xls2kml 1.16.03 to put coordinates from excel to google earth but i want to change icon color "placemark icon color" ... any suggestions ?


to download xls2kml 1.16.03 , try the below link

https://sites.google.com/site/tekgergedan/home/xls2kml/version-history

 

[John_w]

I had a quick look at that workbook. As a minimum, I think you'll have to edit the VBA code to include the < color > tag within the < iconstyle > tag (http://code.google.com/apis/kml/documentation/kmlreference.html#iconstyle) in the appropriate place in the code, with a hard-coded colour value.

To define the icon colour for each row in the sheet you would have to insert a new column to contain the colour values and change the code more extensively to use the colour value from each cell rather than a hard-coded value.

 

[justdream]

Dear John,

I got Macro from internet to draw geometric shapes, I just still need support to do 2 small issues (if you could help)

1) Name to be shown next to each Wedge/ Circle over Google Earth "so shapes could be more meaningful"

2) Description for each Wedge/ Circle over Google Earth "so we could any more helpful information: like this point has serve western area since 1990, etc"