Convert Excel Geographic database to Google Earth KMZ file

[justdream]

Dears,

Could you please supoort to convert Excel Geographic database to Google Earth KMZ file
as shown in below examples (I don't know how to do it) :doh:

[justdream]

I wish macro output to be Google KMZ file with below output

[justdream]

Dears,
is it impossible ??

[AnAnalyst]

Hi justdream,

This is likely to be possible but you may need to be more descriptive.

Looking at what you have presented it appears as if the polygons are to denote something like cell mast coverage (in terms of direction, and angle of coverage in degrees).

This url may provide some useful information about KML:

code.google.com/apis/kml/documentation/kml_tut.html

KMZ is actually a zipped form of KML, and KML is a form of XML.

So first you would need code to convert the co-ordinates, angles and radii into a series of KML files. Some of the more expert VBA gurus may be better at offering a solution to this.

[justdream]

Dear AnAnalyst,

To be more descriptive: Yes, Polygons are to denote cell mast coverage (in terms of co-ordinates, Azimuth and Beam width of each cell could be fixed = 65)

To be honest, I don't know about KML converstion !

[justdream]

ok Dears, I think I could get from internet Macros to convert my Excel coordinates t Google KMl file with required description
but I still need urgently your support to know how to replace defualt Google Earth Icons with geometric shapes (as that one shown above in my earlier post)

Azimuth/ Direction Plus coordinates could be get from my input
and size should be fixed for all
Please guide me for doing this step
Many thanks