Video size: 1280 X 720853 X 480640 X 360
Show player controls
Please, The download link has failed, please update the new Link, and let me ask for the code. Thank!
Hello, I get a run time error when I run this:this is on the line objWebcon,Send (ShtUrl)is there a solution for this please?
i am getting issues when execute your codes but i have already access.Request can you please help me what am i missingrun-time error '-2147024891 (80070005)':Access is denied.
I want to import live data from Google sheet to excel sheet changes in Google sheet live data should also change in excel please help
I am getting error please give correct codes
This is nice and working successfully. IF I want to get a value from a single cell from spreadsheet to any VBA variable then what can be done.?? Please suggest.
This worked great but it only does one sheet. I have 10 google sheets in the same book or https. How can i do it to download them all?
Thanks for sharing the codes its wonderful.
Thanks, It was very helpful. I used this code in VFP
Hello Shakti, this is wonderful. i really appreciated your hardwork. thanks for sharing the knowledge. could you please also tell us how to upload the data from excel sheet to google spreadsheet through vba and the data should be pasted on below of the last row in google spread sheet in consolidation manner
I can use this script for a personal gmail user access but if I use a work Gmail account and we can only share docs with other work users, when the file comes into excel its all just funny code lines and lines of code.
not worked ur link...plz suggest
Wow! It is a very useful code. I also used it in MS Access and it works fine.Thank you for your kindness in sharing this code.
thx ..very helpful.what if, if google sheet is password protected
What if there are multiple sheets on the google spreadsheet....???
+viraj shirsat Remove the code &gid="value"Where value is the gid noBy removing gid you will able to download the workbook with all sheets.