API Json to Excel Macro

I am trying to import the following api json in excel table.
http://api.manilainvestor.com/v1/stocks/hdata/dnl
Can anyone help me develop the code for the macro.

Data must be separated in these coloumns.

Date | High | Low | Open | Close | Volume


Thank you.

This will dump the data in the first sheet, starting at A1

Please Login or Register  to view this content.

Thanks Kyle. You're awesome!

Hi Kyle,

I tried to use your code Excel 2010, I am receiving error message to this line:

Please Login or Register  to view this content.

What's the error?

I am getting the error Run-time error '429' ActiveX component can't create object in the line

Please Login or Register  to view this content.

using Excel 2010 x64.

You should have said that earlier really, MSScript Control is 32-bit and will work on 32-bit versions of Excel (on both 32 and 64-bit windows), but not the 64-bit version.

This will need a complete re-write, I'll have a look when I get chance.

Thanks Kyle.