Use Excel VBA to read API data

Today I'm going to show you how to use Web API's with Excel VBA.

Web APIs may seem a bit daunting at first but by the time you finish this video, you’ll be able to read data from any Web API with ease.

The first part of the video explains the 3 core parts of dealing with Web APIs. It explains each in detail and provides coding examples.

Don't miss the final part of the video where I show a simple method for writing the code for any API.

All the code used in this video is available to download from the link in the description below.

#VBAAPI #ExcelVBAAPI #VBAWebAPI #VBARequestAPI

SUBSCRIBE TO THE CHANNEL: https://bit.ly/3aKHxlY

DOWNLOAD THE SOURCE CODE FOR THIS VIDEO: https://bit.ly/3BRIe92

Related Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives 60+ Hours of VBA training(https://excelmacromastery.com/excelv...)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vbaart...)

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + C OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

Table of Contents:

00:00 Introduction
00:37 What is an API?
04:37 API Code example
07:41 JSON Converter Library
09:27 Reading the converted data
12:20 Understanding the returned data
15:46 Fast method to write any API code