Add VBA to an excel sheet to parse json data

$10-30 USD

In Progress

Posted

about 3 years ago

$10-30 USD

Paid on delivery

I need to automate some data retrieval to an excel sheet using VBA after the user clicks a button. You'll need to add the button and import json function VBA to the sheet - User enters US ZIP code and clicks the button - The macro will import json data of the longitude and latitude of the location - The macro will then import solar irradiance data from NASA website based on the longitude and latitude (I provide the API link and json path for both tasks function).

Excel

Excel VBA

JSON

Project ID: 29490644

About the project

6 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

6 freelancers are bidding on average $37 USD for this job

@myazhar92

Hi there, Hi there, I have gone through your project detail and I am ready to start your project and can add a button for importing json function VBA to the sheet as per your requirement. I am expert in Advance MS Excel, Macro & VBA, and have been working on MS Excel for more than five years, two years as local freelancer + three years in a Multinational Company. I'm pleased to have this project and will be completed on time. I have 50 WPM Typing speed with 100% accuracy. Message me for further discussion or To start your project immediately. What I am going to do if you hire me: =============================== * High discount on First Project. * Project delivery on time. * Unlimited Revisions before closing project. * Excellent Communication Skills * Support 24*7 Thanks & Regards Azhar Uddin

$35 USD in 2 days

4.9

(10 reviews)

3.3

@gaston153

I use excel every day and complicated formulas are my passion. I hope you want to test me. Thank you

$30 USD in 1 day

5.0

(1 review)

0.4

@saelageonzon

Hello! I have years of experience working with Excel models and automations. I work as analytic support which means I would build solutions in the fastest and accurate way possible. Thank you

$30 USD in 2 days