Json file from URL to Excel

My original intent was to try and use this file, but opted to try for the webpage instead. Am able to get the webpage to Excel now, but I can't get the complete page, so I am back to thinking the Json is the way to go.

I copied and pasted Kyle123's code for the PGA leaderboard, it works perfect until I tried to modify it to the page I want. I only need five columns, but kept the twelve in Kyle123's example for the sake of seeing if I could make it work. Right now I am getting a subscript out of range error.

I want to name the sheet Zip77477 and the five parts I need are "podList", "name", "desc", "summary", "expiration".
If I need to keep other data in the sheet to make it work properly, that is fine as well.
This is the code and my modifications, any help is greatly appreciated.

Please Login or Register  to view this content.

I have tried to modify the code in Kyle123's example to work for the json I am trying to retrieve. I am getting a getting a "subscript out of range" error, can anyone help me find out why? Thanks

Please Login or Register  to view this content.

You aren't a million miles away, like this:

Please Login or Register  to view this content.

Thank you, this script works perfect, however I have one more question.

I would like to do multiple sheets in one workbook, each sheet representing a different zipcode.
The only two lines that change within the script are the URL

Please Login or Register  to view this content.

and what sheet

Please Login or Register  to view this content.

I have each sheet with a corresponding module. When I run the macros for the new sheet(33317) it returns the data from 77477. What do I need to do so that each module with each zipcode returns different data?