Hi all,
I hope I came to the right place for my issue. I am programming a vba macro in excel and are okay-ish with basic commands. However, what I try to achieve this time is beyond my current knowledge.

As part of my macro which runs every 30 minutes I would like to receive some info from a webpage (currency exchange with price tickers, etc.). This webpage offers an API, I am only interested in the public one to receive publicly available data. Once finished I would like to distribute the Excel file to different users / operating systems etc. So whichever libraries, etc. should be required, they should be saveable in the excel sheet so other users don't need to go through a setup process.

Here is the info page of the relevant API: https://bittrex.com/home/api
I am specifically interested in the data of /public/getmarketsummaries. I would then write some code to compare prices, volume, etc. so I need to find out how to address those values and put them into variables once the data is received.

Is this achievable for a fairly unexperienced VBA programmer?

Thanks in advance for your help!

BR
JDot