• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Code: VBA Google Earth KML File Placemarks (1 Viewer)

ironfelix717

Registered User.
Local time
Today, 19:01
Joined
Sep 20, 2019
Messages
87
Finally after some long hours, I was able to cobble together some code to work with KML files in VBA/Access.
The attached example includes an object that allows for the following features....

**this code is focused on placemarks only and does not support any other GE geometry (i.e. paths)**

1.) Creating a KML file from scratch quickly by specifying coordinates, name, etc.​
-Includes up to 10 custom marker types​
2.) Parsing Placemarks from KML file to VBA​
3.) Parsing Placemarks from KML file directly to Access Table.​

Items 2 and 3 are especially valuable to me because all the "solutions" that exist don't return reliable data (missing data pieces, including folders/subfolders in data set). This code extracts just the placemarks and has no regard for the folder/subfolders that the placemarks in the source file might exist in.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
What I learned:
XML is a terrible data solution which I now have a love/hate relationship with.

Credits:
No individuals in particular. Other forum contributors on the web who have messed with KML/XML stuff. Thank you.

Closing:
I won't maintain this code unless a large bug is found. It was thrown together quickly and I hope its valuable to someone.



Regards----
 

Attachments

  • KML Parse Example 6-23-20.zip
    61.5 KB · Views: 32

Users who are viewing this thread

Top Bottom