Connect to API in Excel Part 1/2: Send API Request

In this video we will see how to get data from a web API in Excel using VBA macros. As an example, we are getting data form a public API with information about universities around the world. This API does not require any API key to be used, and consists of a simple URL that accepts a single parameter to specify the country of interest. The Excel VBA macro code to send an API call and retrieve information or data from the API consists of two steps. In this video we will cover the first step, which consists of sending an HTTP request to the API URL, in a similar way we have done to scrape web data in a previous video (Scrape Web Data in Excel Part 1). In the next video we will see how to read the API response returned as JSON format, and retrieve the list of universities for a given country.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[rubensluz]

Very good explanation brow!! Thank you a lot!!!

[TheSardOz]

Excellent video, looking forward to seeing the next one! Thank you!

[blessinagolle]

can u do a vedio on how to do excel file req with nodejs and req from html webpage..tq

[Luffy-jfep]

Hi,
Can you tell me please how to transfer data from vba to excel sheets
I have got data from api call and parsed it and now I have something ticket number stored in a variable in a vba and now I want that big column like output in immediate window to go to excel sheet .

[michaelklein]

Show how to do a post request with a json payload

[garlandgimen]

What if the url I need to access requires API Key? where/how to add it? :) thanks!

[SnehalShivkar-uukm]

i am calling same macro in my side giving me error ActiveX component cann't create object

[minakshideb]

While trying to use the code I am getting access denied error in send section