title: Mapping JSON/XML data to Excel cell in VBA?
body: <p>I'm asking this after some researchs on internet. There's a way to JSON type or XML type files to import Excel sheet but there's no clear descriptions found for my case. I would like to what is my goal;</p>
  
  <p>I have a some type of string data like .txt file like this;</p>
  
  <p>Example Data:</p>
  
  <pre><code>{"vehicle1": {
    "title": "A super red vehicle",
    "weight": "1500 kg",
    "height": "2 m",
      "vehicle1-center_of_gravity": [
        {"x": "2 m"},
        {"y": "-0.5 m"},
        {"z": "1.5 m"}
       "vehicle1-passenger_weights": [
       {"p1": "2 m"},
       {"p2": "-0.5 m"},
       {"p3": "1.5 m"}
      "color": "red",
      ]
    }
  }}
  </code></pre>
  
  <p>I would like to select this file with file dialog and then click to read button now my question comes in here. Is it possible to link/map them with cells for example i have cell named <code>vehicle_title</code> and i want to map this cell with .txt file's <code>"title": "A super red vehicle"</code>.</p>
  
  <p>Do you have any experience or idea how can i implement that to my macro.</p>
  
  <p>Regards.</p>