Import Data From Google Sheets via Web Query Excel VBA Macro

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:

[MakeItHappenWithVisualBasic]

Hi! I can see that this is your passion as well. Extending VBA's capabilities to an online database requires both skill and persistence, and your work is truly commendable. I’ve also worked on this area and created a custom library that connects VBA to Google Sheets and Drive. Keep up the amazing work, and God bless you, sir!

[rhymeswithyourmom_]

Exactly what I needed. Worked perfectly! Thanks.

[PedroSilva-bcgy]

Thank you, excellent material and explanation. Subscribed!

[SwissMarkus]

brilliant tutorial ! thank you very much for sharing your know How👍
question: my Google-Sheet(Table/File) contains 5 different sheets what will I have to specify in order to import let's say Sheet named "Monday" ?

[georgiivanov]

Great video, very informative and easy to follow. Is there a way to pull data from a private google sheet file, not a public one?

[JonelAlboroto]

Wow, it works perfectly and very simple. thanks a lot
Question: is it possible to also import all format and formulas? or maybe import an excel file from google drive?

[martinpintado]

Great job. I am using it, but, for my purpose I need access the data before macro (Sub) execution end. ¿Is it possible? As far as I saw, the data is available once all macros executions ends.

[jcmerlob]

hi, thanks for your video. do you think you could overwrite the web database with VBA?

[tulioh.r.r.]

Hi, It works perfectly, but I need to be able to do it on a restricted google sheets, is there any way to approve credencials inside VBA?

[ruangbelajarku]

Great Video, but when i use button execution more than once.. debug.. ActiveSheet.QueryTables(1).Delete, please help solution

[ruangbelajarku]

Sir I have userform to used some user, I iwant user only import data Last Row from last entry and loop to next row all data. any video tutorial this condition? thanks before

[apidetdamrongsuntisuk]

can you help me my column header in th browser is blank then when i run macro there is no header in my excel file. thank you . sory for my english is very bad

[rockonlyrock]

How do I implement readystate_complete I would like to prompt MSGBOX completed. Much Appreciated

[phoneusphoneus]

Your video is really useful for me but I need to make your macro can upload specific cells and import a specific cell too.

I have a custom function on Google Sheets that can calculate distances through google maps.
Unfortunately, this function cannot be programmed within Excel VBA

However,
The custom function contains 6 arguments:
=GOOGLEMAPS_DISTANCE(origin, destination, mode, waypoints1, waypoints2, waypoints3)

I need to create a function within my excel file that can:

- Connect to a Google Sheet file.
- Copy the values of its arguments to google sheets to cells B3, C3, D3, E3, F3, G3.
-Imports the results of my custom function in google sheets from cell C7.

So is this possible within Excel VBA?
And if possible how can I do that?

[MrInchez]

Can you specify a sheet on the google sheet?

How would the url change?

[jpl]

Is there a possible way to transfer selected items from google sheet to excel using VBA?

[asiam]

Hi Sir, i need help you, how get data from web by date to date excel vba

[yllazora.]

is it not really possible to import data to excel from google sheet if the google sheet is not public? Is there no other way for that case?