Import RESTRICTED data from Google Sheets Part 2/2

See various methods to import data from Google Sheets here: https://excelmacrofun.blogspot.com/20...

In the previous video we saw a method to import RESTRICTED data from Google Sheets in Excel using VBA macros. The method consists of creating our own Google script API and then sending a HTTP request from Excel to get the data. In this video we see how to read the response to write the data to a range in Excel. We can loop through the JSON response to extract the data using basic VBA functions. We can also update the code to get the response as HTML so that we can use the native Excel library to easily read the HTML table.

Find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners and Excel VBA Objects Guide for Intermediate) in the blog spot: 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/)