How do I consume Zerodha APIs through Microsoft Excel VBA?

dhansap

Hi, I am trying to get live stock prices and other relevant information into an Excel sheet. I will also be doing functions like Place order. How do I access Zerodha APIs using Excel VBA code to do the above operations? Please guide. Thanks.