Is Excel VBA able to manipulate and pull data from a non-standard file (eg. a KML file)?

Track.png

Go ahead and look up "Algarve Race Resort, Portimão, Portugal" in Google Earth (GE). The F1 race course is slightly South of the GE destination result, but easily found. The data above is the lat, lon data in a Scatter with Smooth Lines and Markers Chart. You find it matches the race course, or at least part of it.

I thought I pulled all the lat, lon data from the KML file into Excel, but obvioulsy I missed some pairs . It already took a bit to do what I did, so in pulling in the rest of the data I asked myself Is there a better way? Is there an automatic way? It's a fairly straight-forward process as this is how a KML file appears in Notepad.

Track2.png
  1. Plot a PATH in GE and save it
  2. Right-click on the path and SAVE AS a KML file
  3. Open the KML file in Notepad
  4. Pull the lat, long data from between the coordinates tags
  5. Apply the lats into column A; the lon into column B, and create a Scatter Chart from it.

I began writing a macro to open the KML file only to quickly realize that I dont know if Excel VBA can even manipulate a non-standard file such as a KML file. Ideally I'd ask the macro to pull the data from between the coordinates tags and deliniate via the comma.

Thoughts? Methods?