Tabellab
Menu
Courses Guides Pricing Log in Start free
Advanced

Web, APIs & JSON

Call a web service from a macro, survive the things that go wrong, and get the answer onto a sheet.

8 lessons 1.1 h Certificate

Start the course Unlock all courses

The first lesson is free — no account needed.

About this course

Call a web service from a macro and get the answer onto a sheet. You learn how VBA talks to the web, send GET and POST requests, handle status codes, headers and API keys, get an honest assessment of JSON in VBA with simple parsing without a library, and deal with timeouts, retries and rate limits.

Lessons

  1. How VBA Talks to the WebReading11 minFree
  2. Your First GET RequestReading7 min Pro
  3. Status Codes and Handling FailureReading7 min Pro
  4. Headers, POST and API KeysReading8 min Pro
  5. JSON in VBA: an Honest AssessmentReading8 min Pro
  6. Simple Parsing Without a LibraryReading8 min Pro
  7. Timeouts, Retries and Rate LimitsReading7 min Pro
  8. Putting the Results on a SheetReading8 min Pro