...extensive kml support including the timeline)

• Creation of grids
• Creation of statistical bars (1 to infinite edges)
• Paths and polygons with their styles
• Nesting folders
• Flexible application of the time stamps
• Ability to tune placemarks, paths, polygons, and other features if there is a shift in the image in GE
• Ground overlays and screen overlay
• DMS support for lats and longs
• Address entry instead of lats and longs
• Use of formulations on the spreadsheet

xls2kml, ods2kml, and two more tools

Visit HERE for the old-time discussions in our Support forum.

Does the Excel to KML workbook support the <gx:balloonVisibility> tag. As I understand it this ensures that the balloon is open when the file loads in Google Earth.

Or is there an alternative way of achieving this?

Thanks.

<gx:balloonVisibility> has been introduced lately. There are a lot of features not included in that version. However, most of them can be done by editing the macro. For <gx:balloonVisibility>, try this:

- Enter an ID for the placemark whose balloon you want to open. For instance, set "visball" (without quotes) as the ID. Be sure row 3 for the ID column is not empty.

- Switch to the macro (Alt-F11)

- First, since it is a kml update in question, you need to find
<kml xmlns=""http://earth.google.com/kml/2.1"">
and replace it with
<kml xmlns=""http://www.opengis.net/kml/2.2"" xmlns:gx=""http://www.google.com/kml/ext/2.2"">

- Find the line A.WriteLine ("<Point>")

- Add this code above it:
if varPlcmrkID="visball" then A.WriteLine ("<gx:balloonVisibility>1</gx:balloonVisibility>")

Hope that helps

Thanks, I suspected that I needed to do something like that. What I had not thought through was the link to the ID.

Cheers.

Hi,
excellent tool, thanks for it. I'm wondering if you could tell me how to amend the code so that I can add a column to regulate the size of the icon according to a specific value.

Thanks, I'm quite a newbie to this VBA so appreciate your help.

Bernard

Hi Bernard,

Please download the new version. Now it is able to resize the icons. Can you also verify if it works fine? Hopefully, it won't produce an error because of the decimal point which is comma with me.

Vorley, please feel free to let me know anything further you are in need of.

Thanks for the new version, it works well.
I was trying to work through this problem only yesterday,
and I was just changing the scale in the VBA code.
Another problem I was having is the scale of the label.

I am producing a google earth map of a water network consumer database using your code (thank you very much)
There are 800 to 1000 points to map, I am currently producing the file (3.5mb) and changing the style in GE to reduce the label size to zero, however I would prefer if the code produced the kml.

Is this possible.
Best Regards
Shane
inshoresurveys at gmail.com

EDIT:
This wish by archisurveys has been adopted in v.1.16.03.

Hi Tek,

Whenever I try to open a .kml file created by xls2kml, I get a "parse error: not well-formed (invalid token)" error.

I have tried everything I could find to solve this, but no luck so far. Could it be because my data has 798 records? The only thing I haven't tried is breaking it up into sets of <200.

Any help is much appreciated,
-Ryan