title: Excel to json file from Excel VBA
body: <p>I want to have a button in an excel document (using VBA) which, takes in the data on the sheet and outputs a file (.json). Which I can then use later on within a web page.</p>
  
  <p>I my excel data looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/Qyhdy.png" alt="Image of excel table"></p>
  
  <p>Note  I would like to have more than one instance of data.
  I want it to generate a json file in the format of:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>{
   "Excel_test": [
    {
     "name" : "tesintg1",
     "age" : 15
    },
    {
     "name" : "testng2",
     "age" : 1
    },
    {
     "name" : "testing3",
     "age" : 435
    }
   ]
  }
  Thanks</code></pre>
  </div>
  </div>
  </p>