Small Adjustment to VBA script to parse nested field in a url JSON feed

$10-30 USD

In Progress

Posted

over 3 years ago

$10-30 USD

Paid on delivery

I have VBA subroutine that scrapes data from a url JSON feed. The feed has been altered recently and now a few of the field I need are now nested in a way that I don't know how to parse them. I have attached the script I am using. All code in this script works EXCEPT the code that scrapes the R1, R2, R3, and R4 fields in the jason feed. I have also attached a snippet of the JSON feed and I highlighted the fields that I am looking to parse.

Excel VBA

JSON

Excel Macros

Project ID: 28150298

About the project

2 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@tracygearth

I have good hands on in VBA and database table fields management. anuj

$25 USD in 1 day

3.8

(1 review)

0.5

2 freelancers are bidding on average $25 USD for this job

@akritisood94

Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project. Also, I can send some of my VBA apps. I can complete your job successfully in your mind. Wishing for your response. Let me try at your job. Thanks

$25 USD in 1 day