Converting kml to kmz

Question

5.00/5 (1 vote)

See more:

Does anyone know how to convert a kml file to a kmz file programmatically in vba excel.

I am able to convert kml files to kmz mannually by opening a kml file in Google earth and going to File->Save->Save place as, like this i am converting it to kmz files.

But i want to convert programmatically in vba as, if we give input to macro as kml it should have to convert into kmz file .

I had explored this i found some conversion tools like kmlkmz converter which will does this process automatically but i am supposed to do this in vba .So please suggest if any one know this.

Posted 30-May-12 3:25am

PraveenKumarReddyChinta

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Answer 1 · 2012-05-30T03:43:00

It is quite easy when you read about the structure of KMZ here: KMZ Files[^]. You won't be needing any supporting files if your original KML file does not reference external files:

Here an excerpt from the site above I linked to:

Goggle Developers wrote:

Create a folder that will contain the contents of your KMZ file. Give it a descriptive name (for example, buffetthawaiitour).
Put the default KML file (doc.kml, or whatever name you want to give it) at the top level within this folder. Include only one .kml file. (When Google Earth opens a KMZ file, it scans the file, looking for the first .kml file in this list. It ignores all subsequent .kml files, if any, in the archive. If the archive contains multiple .kml files, you cannot be sure which one will be found first, so you need to include only one.)
Include one or more subfolders within the main folder to collect images, models, textures, sound files, or other resources referenced in the doc.kml file. The complexity of this directory structure depends on the number of supporting files and your preferences for organization.
Use relative references. See References to External Files for more details. All relative paths begin inside the base folder described above in item 1. For example, if a KMZ file vacationJournal.kmz is on the desktop, and its doc.kml file refers to a file myFavoritePlace.jpg, which is also on the desktop, the href in the doc.kml file is ../myFavoritePlace.jpg.
Do not use the .kmz extension for any of the subfolders within a KMZ file. The .kmz extension is reserved for the name of the archive itself.

Regards,

Manfred