Connect to API in Excel Part 2/2: Read API JSON Response

Find the code here: https://excelmacroclass.blogspot.com/2022/05/connect-to-api-excel-vba-macro-part-2.html In the previous video we have seen how to connect to a web API in Excel using VBA macros. In this video we will see how to read the API JSON response in Excel and retrieve the data of interest. In this macro example, the data is the list of universities for a given country. The web API is public and does not require any API key to be used. There are different ways to read a JSON file in Excel. We will use a simple method of string manipulation to get the name of each university for a given country. You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the Excel Macro Class blog under the link: https://excelmacroclass.blogspot.com/ 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: Excel Macro Fun (https://excelmacrofun.blogspot.com/) Excel Macro Business (https://excelmacrobusiness.blogspot.com/) Excel Macro Sports (https://excelmacrosports.blogspot.com/)