Тёмный

Integrate VBA Project with Google Drive using GoogleApisVBA Library - Basic Version 

VBA A2Z
Подписаться 51 тыс.
Просмотров 17 тыс.
50% 1

Connect Google Drive and Sheets using VBA. Read, Write, Upload, Download, List files, Create, Delete, and more
Check out the premium version here • VBA to Read, Write, Up...
Please like, share, and comment to improve the channel algorithm
👉 Subscribe to receive our latest content ru-vid.com?sub_confirm...
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

 

6 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 237   
@VBAA2Z
@VBAA2Z 3 года назад
Quotas for Google Services * 10 queries per second (QPS) per IP address * Requests per 100 seconds per user developers.google.com/apps-script/guides/services/quotas developers.google.com/analytics/devguides/config/mgmt/v3/limits-quotas
@YuYueTongXing
@YuYueTongXing 3 месяца назад
Hi, Where to download googledrivevba.msi the installer?
@VBAA2Z
@VBAA2Z 4 года назад
Find the link to download Library from here: Do not forget to Like, Share & Subscribe! Thanks. bit.ly/google_api_for_vba
@bhakthasingh8198
@bhakthasingh8198 4 года назад
You are so good, Pamai. Sharing all these valuable knowledge at no cost.
@VBAA2Z
@VBAA2Z 4 года назад
thanks for your kind words. I appreciate that!
@Roberto-ui6nc
@Roberto-ui6nc 3 месяца назад
Sorry to bother you, I'm trying to see where the bookstore is but I can't find it anywhere, I've contacted Palmai but he doesn't respond, could you please provide me with the file. Thank you so much. Greetings.
@holieh5301
@holieh5301 4 года назад
Thanks much Pamai. I’ll definitely try out share my observations. Keep developing cool libraries like this for VBA developers.
@VBAA2Z
@VBAA2Z 4 года назад
Thanks Holie. Would really appreciate your feedback.
@Roberto-ui6nc
@Roberto-ui6nc 3 месяца назад
Sorry to bother you, I'm trying to see where the bookstore is but I can't find it anywhere, I've contacted Palmai but he doesn't respond, could you please provide me with the file. Thank you so much. Greetings.
@munimrashid7065
@munimrashid7065 3 года назад
Wow you have explored so amazing supports for VBA that takes it to web enabled application development!
@VBAA2Z
@VBAA2Z 3 года назад
Thanks!
@SaraPerzYT
@SaraPerzYT 4 года назад
You surprise us with your amazing contents. Keep it up, Pamai!
@VBAA2Z
@VBAA2Z 4 года назад
Thank you! Will do!
@Roberto-ui6nc
@Roberto-ui6nc 3 месяца назад
Sorry to bother you, I'm trying to see where the bookstore is but I can't find it anywhere, I've contacted Palmai but he doesn't respond, could you please provide me with the file. Thank you so much. Greetings.
@perymdiso1006
@perymdiso1006 4 года назад
Wow this is so cool. Thanks Pamai.
@VBAA2Z
@VBAA2Z 4 года назад
Glad you like it!
@mnewmai9413
@mnewmai9413 3 года назад
Amazing work vbaa2z!
@VBAA2Z
@VBAA2Z 3 года назад
Thank you 🙌
@user-uv1uf8cr3b
@user-uv1uf8cr3b Год назад
Thanks for sharing all this valuable knowledge at no cost.
@VBAA2Z
@VBAA2Z Год назад
Glad it was helpful!
@Rahul-sn1wn
@Rahul-sn1wn 4 года назад
Thank you so much Pamai I’ll definitely give it a shot
@VBAA2Z
@VBAA2Z 4 года назад
Hi Rahul - You're welcome. Thanks for your support.
@VBAA2Z
@VBAA2Z 3 года назад
Download Library: Please refer to Free Projects / e-Course section from the below link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@HarshlyHarshly-fs9sn
@HarshlyHarshly-fs9sn Год назад
Thanks Pamai for amazing video
@VBAA2Z
@VBAA2Z Год назад
So nice of you
@azel2239
@azel2239 4 года назад
Great work Pamai. Really appreciate your contributions to community. Some suggestions for next updates - Provide access via program to email id - Query Options where Developers can specify Custom query statements like showed in .Net videos. Like query by file name, time, user access, etc. Thanks again
@VBAA2Z
@VBAA2Z 4 года назад
Thanks for the idea!
@Varun-dh4mr
@Varun-dh4mr 4 года назад
You’re the man! Cheers!
@VBAA2Z
@VBAA2Z 4 года назад
Thanks my friend.
@linnick9235
@linnick9235 4 года назад
Thank you sooo much. Brilliant!
@VBAA2Z
@VBAA2Z 4 года назад
You're very welcome!
@LeverageLean
@LeverageLean 3 года назад
Can't wait to get started using this powerful VBA Code! #LessClicksMoreResults
@VBAA2Z
@VBAA2Z 3 года назад
hope it helps. Cheers!
@alexchristensen2651
@alexchristensen2651 3 года назад
Thank you so much for the amazing work!
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching.
@sasavelickovic7948
@sasavelickovic7948 3 года назад
Great tutorials and useful codes Well chosen topics Thanks!
@VBAA2Z
@VBAA2Z 3 года назад
You are welcome!
@teradhikatechnology7721
@teradhikatechnology7721 3 года назад
Thank you again for this video..
@VBAA2Z
@VBAA2Z 3 года назад
Always welcome
@_ednodete
@_ednodete 3 года назад
Very helpful. Thank you
@VBAA2Z
@VBAA2Z 3 года назад
Glad it was helpful!
@Luangdi-xd3ll
@Luangdi-xd3ll Год назад
Thank you so much for you amazing tutorial
@VBAA2Z
@VBAA2Z Год назад
You’re welcome 😊
@user-iu2yk7pu1c
@user-iu2yk7pu1c 9 месяцев назад
Thank for amazing tutorials
@VBAA2Z
@VBAA2Z 9 месяцев назад
Glad you like them!
@mr.k8095
@mr.k8095 3 года назад
This video is very helpful for my university work. Thanks a lot!!!
@VBAA2Z
@VBAA2Z 3 года назад
Glad it was helpful!
@Roberto-ui6nc
@Roberto-ui6nc 3 месяца назад
Sorry to bother you, I'm trying to see where the bookstore is but I can't find it anywhere, I've contacted Palmai but he doesn't respond, could you please provide me with the file. Thank you so much. Greetings
@craigharris9590
@craigharris9590 3 года назад
Pamai, thankyou for sharing all this valuable knowledge.
@VBAA2Z
@VBAA2Z 3 года назад
My pleasure
@craigharris9590
@craigharris9590 3 года назад
@@VBAA2Z Hey Pamai, I'm really excited about trying this. Wondering where to download it from. Thanks in advance!
@VBAA2Z
@VBAA2Z 3 года назад
Please check below project from the link 021 - GoogleapisVBA (free version) 096 - GoogleApisVBA Premium vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@pzoli2001
@pzoli2001 3 года назад
Great work, thanks
@VBAA2Z
@VBAA2Z 3 года назад
Glad you liked it!
@baptmth296
@baptmth296 3 года назад
Impressionnant !
@VBAA2Z
@VBAA2Z 3 года назад
thanks!
@baptmth296
@baptmth296 3 года назад
@@VBAA2Z thank you for this tutorial would it be possible to have a tutorial to use Gmail and GCalendar?
@betofernandes
@betofernandes 3 года назад
Excelente tutorial !!!!
@VBAA2Z
@VBAA2Z 3 года назад
thanks for watching.
@jarod9856
@jarod9856 3 года назад
Thank you so much for this video, extremately useful
@VBAA2Z
@VBAA2Z 3 года назад
You're very welcome!
@josedejesusmartinez5113
@josedejesusmartinez5113 3 года назад
Thanks a lot, very helpful!
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@luaiwaqqad8331
@luaiwaqqad8331 3 года назад
thanks pamai :)
@VBAA2Z
@VBAA2Z 3 года назад
You're welcome
@stefanozito
@stefanozito 3 года назад
amazing content! good boy!
@VBAA2Z
@VBAA2Z 3 года назад
thanks
@dinawangjkiu9712
@dinawangjkiu9712 Год назад
thank you. I am looking to try this.
@VBAA2Z
@VBAA2Z Год назад
Please do!
@Noune-fp2qr
@Noune-fp2qr 11 месяцев назад
Thanks for the video tutorial it helped me out alot ^^
@VBAA2Z
@VBAA2Z 11 месяцев назад
Glad to hear that!
@wikamdiopekiang4972
@wikamdiopekiang4972 2 года назад
you're the best!!!!! thank you
@VBAA2Z
@VBAA2Z 2 года назад
You're welcome!
@ArupRoy_fromPlanetEarth
@ArupRoy_fromPlanetEarth 3 года назад
Great Job!
@VBAA2Z
@VBAA2Z 3 года назад
Thank you! Cheers!
@denemedeneme7866
@denemedeneme7866 3 года назад
thank you for this lesson
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@matnz7546
@matnz7546 4 года назад
Thanks for another great tutorial and sharing the library for free. This is going to compliment my project which is built on Access db. Quick question, if I want all users to access single/same drive I should opt for service account?
@VBAA2Z
@VBAA2Z 4 года назад
Fantastic! yes go for service account. regards
@jlbarba2910
@jlbarba2910 3 года назад
Video very useful. Thx.
@VBAA2Z
@VBAA2Z 3 года назад
Glad it was helpful! thanks for watching.
@azizmamatismanov3092
@azizmamatismanov3092 3 года назад
Thank you very much
@VBAA2Z
@VBAA2Z 3 года назад
You are welcome
@wangniperinmai
@wangniperinmai Год назад
thank you very much.
@VBAA2Z
@VBAA2Z Год назад
You are welcome!
@hoseal8048
@hoseal8048 4 года назад
Awesome thank you
@VBAA2Z
@VBAA2Z 4 года назад
No problem!
@wennychez5606
@wennychez5606 4 года назад
Thank you so much sir.
@VBAA2Z
@VBAA2Z 4 года назад
Most welcome.
@WeningWang
@WeningWang Год назад
thank you so much!
@VBAA2Z
@VBAA2Z Год назад
You're welcome!
@sergionambol313
@sergionambol313 Год назад
this is amazing, thank you
@VBAA2Z
@VBAA2Z Год назад
Glad you like it!
@tihomirpopovich
@tihomirpopovich 3 года назад
Great job...
@VBAA2Z
@VBAA2Z 3 года назад
Thanks
@benjaminf5731
@benjaminf5731 Год назад
thanks alot!
@VBAA2Z
@VBAA2Z Год назад
Glad it helped!
@mohammedalsarraj9963
@mohammedalsarraj9963 3 года назад
Really helpful
@VBAA2Z
@VBAA2Z 3 года назад
Glad it helped
@dg1623
@dg1623 2 года назад
Great
@VBAA2Z
@VBAA2Z 2 года назад
Thanks!
@hizinbygr2357
@hizinbygr2357 Год назад
thank you
@VBAA2Z
@VBAA2Z Год назад
You're welcome
@m-squaredcontractors9720
@m-squaredcontractors9720 4 года назад
Thank you for the amazing tutorial. You are in a class of your own. Is the approach the same using Microsoft Azure or OneDrive?
@VBAA2Z
@VBAA2Z 4 года назад
This library is specifically designed using Google Drive API. But yes, we can also build something for Azure or OneDrive too.
@m-squaredcontractors9720
@m-squaredcontractors9720 4 года назад
@@VBAA2Z Thank you for the quick response. How can one engage you for assistance for a fee of course?
@MyAudioBookCompilation
@MyAudioBookCompilation 3 года назад
Your one of the best man. Thank you.
@VBAA2Z
@VBAA2Z 3 года назад
Thanks. Please do not forget to subscribe, thanks for your support.
@MyAudioBookCompilation
@MyAudioBookCompilation 3 года назад
@@VBAA2Z Yes I have subscribed already. I will promote your channel in my future video once I recommend where to find advance level tutorials specially API lessons.
@VBAA2Z
@VBAA2Z 3 года назад
@@MyAudioBookCompilation thanks. APIs are everywhere. All big enterprise tools pretty much provide APIs (in simple terms channel or ways ) to connect with their solutions/services. If you're interested in these I'd suggest you start learning .net where you can program F#, C#, VB. All the best! Here is example for google drive apis = > developers.google.com/drive
@MyAudioBookCompilation
@MyAudioBookCompilation 3 года назад
@@VBAA2Z Thank you thank you. Your a great person.
@VBAA2Z
@VBAA2Z 3 года назад
@@MyAudioBookCompilation you're welcome!
@kinga334
@kinga334 4 года назад
Thanks sir for another brilliant tutorial. Will love similar library or within same library to read write to google sheets from VBA. Quick question, when using user (OAuth 2.0) the App will request consent from user and it only access the the drive the permission is given to? I understand for service account the app does not request consent because it is can only access the service account drive irrespective of the user.
@VBAA2Z
@VBAA2Z 4 года назад
Thanks for your suggestions. I've something in Google Sheets API too. I'll try and include it in the next version. Coming to your question, yes that is correct. VBA Project App will access the drive of the respective users it has consented.
@sunil5149
@sunil5149 4 года назад
This is Super! thanks Pamai. Can we read and write to files in the Drive too?
@VBAA2Z
@VBAA2Z 4 года назад
There are APIs for that (Google Sheets) too however in this custom library Sheets API are not included.
@sajd19
@sajd19 3 года назад
Thanks Buddy
@VBAA2Z
@VBAA2Z 3 года назад
No problem 👍
@mimocrocodile5069
@mimocrocodile5069 3 года назад
Great video. Thanks a lot. Very useful. Just a couple of days ago I had such a problem and I could not find a solution. But how to download the library? I filled the request form but did not receive anything. (There is nothing in the spam folder either)
@VBAA2Z
@VBAA2Z 3 года назад
Great to hear! thanks. All request have been processed please be sure to check Spam folder too.
@youcefmerah5707
@youcefmerah5707 2 года назад
thanks
@VBAA2Z
@VBAA2Z 2 года назад
You're welcome!
@winterspring997
@winterspring997 3 года назад
Hi .thanks for your learnings.I want to know how to get count property and name of enum constants or enum number with for each or for next loop.for example this : msoshape16point star and etc
@VBAA2Z
@VBAA2Z 3 года назад
Hi, you're welcome. are you referring to PowerPoint shapes?
@migueldacosta1778
@migueldacosta1778 3 года назад
It would be interesting to see if you would be able to automatically run a function to obtain the WebviewLink and the WebContentLink of files in the get list fields for us too, this will help in the automation of sharing files without having to open google drive and giving permissions, I have sent you an email asking something similar few days ago.
@VBAA2Z
@VBAA2Z 3 года назад
Will be releasing premium versions with all these features included soon
@dovacmarlon7493
@dovacmarlon7493 4 года назад
Thanks for your amazing video. I want to ask if it is possible to add a method() that returns a direct download link to a specific file or files?
@VBAA2Z
@VBAA2Z 4 года назад
Sure Donav, I'll include the link in file attributes in next version.
@dovacmarlon7493
@dovacmarlon7493 4 года назад
Thanks Sir. Keep up the good work.
@florincopaci6821
@florincopaci6821 4 года назад
Hello Sir, I want to ask you and i apologize for the question because it has nothing to do with the topic-will you continue with the series of vba for beginners? Thank you!
@VBAA2Z
@VBAA2Z 4 года назад
Don't worry, please ask
@migueldacosta1778
@migueldacosta1778 3 года назад
or set permissions as you did in the googledrive api to .net project.. please help
@scottansir7708
@scottansir7708 4 года назад
Can you please add permission capabilities? thanks, this is very useful.
@VBAA2Z
@VBAA2Z 4 года назад
Yes, sure.
@caiglynferguson1860
@caiglynferguson1860 2 года назад
Hi, I've been using version 1.0.7 to download a file from Google drive but in the last two weeks it has been returning a "Service Failed" response even though nothing has changed. Is this related to the Google API credentials or the .dll files?
@VBAA2Z
@VBAA2Z 2 года назад
This version has been discontinued. Please check out below link for updated versions vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@mrrcomp
@mrrcomp 2 месяца назад
HI Excellent overview.. is there a link for the code and excel sheet? didnt find it on your site Keep up the good work Regards
@VBAA2Z
@VBAA2Z 2 месяца назад
please check GAPIS section pamaitech.com/downloads/
@DavidDanosTech
@DavidDanosTech 3 года назад
Great job man. Could you tell me how to get all the files from my drive? it gets only the first 100 I think.
@VBAA2Z
@VBAA2Z 3 года назад
will recheck and come back. thanks for sharing your observation.
@majavelickovic99
@majavelickovic99 3 года назад
@@VBAA2Z have you found an answer to this maybe? It gets me only the 1st 100 too
@eliasmurillo1715
@eliasmurillo1715 3 года назад
Thank you so much Pamai, In the Function GoogleapisVBAList, ¿Can I list the content of determinated ID folder? I don´t see how to parameterize that and i see all the content shared with me
@VBAA2Z
@VBAA2Z 3 года назад
Currently it list all of them. I can add more functions in next update
@eliasmurillo1715
@eliasmurillo1715 3 года назад
@@VBAA2Z It would be great if it be possible! :)
@jeanstevencharles3613
@jeanstevencharles3613 3 года назад
Hello,i have a vba project and i wanna know if it possible to store client’s information in a cloud and permit the clients to get access to it( only informations related to that client)when needed ( by using the vba project)
@VBAA2Z
@VBAA2Z 3 года назад
Hi Jean, it depends on how you implement them. You can read and write to google sheets.
@stafadriaensen4496
@stafadriaensen4496 8 месяцев назад
I want to copy the user.json and theservice.json to the folder, but where is that folder? Must I download it first?
@VBAA2Z
@VBAA2Z 8 месяцев назад
can you store these connection credentials to any folders, then point your code to look for this file for connection
@3Starsgamer34
@3Starsgamer34 Год назад
Hi , I tried hard but could not find library to install for VBA reference. Can you share link of setup file
@VBAA2Z
@VBAA2Z Год назад
Please refer to GoogleApisVBA Premium Subscription vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@mokakoka100
@mokakoka100 3 года назад
How to do the same for Access 2016? would you please do another video for access
@VBAA2Z
@VBAA2Z 3 года назад
Hi, This is VBA so it is not specific to Excel. This can used from any VBA Editor. Simply use same function by referencing it via Access VBE Reference
@yashchawla8360
@yashchawla8360 4 года назад
Is there any solution for google maps? Any way to pull distance for cabs and other vehicles?
@VBAA2Z
@VBAA2Z 4 года назад
In VBA you can use REST API along with Google Maps API to achieve this.
@yashchawla8360
@yashchawla8360 4 года назад
@@VBAA2Z This is new to me sir, But I'll give it a go
@ekilunewmai7033
@ekilunewmai7033 Год назад
Can this library be used for updating data in Google sheet?
@VBAA2Z
@VBAA2Z Год назад
Please check this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XZ43G4rRqbI.html
@catfelix18
@catfelix18 3 года назад
Great video, thanks so much for the information. However, I can't get your library to register properly. I get "Class Not Registered" on the "gDrive.startservice (CredInfo)" line of the SetInfo function. It iterates fine through the CredInfo function but the error appears when trying to start the service. Any ideas??
@VBAA2Z
@VBAA2Z 3 года назад
Please share Windows and Office Bit version. Did you encounter any errors while installing? Remember the app uses .NET 4.7.2 if it is not in your system.
@catfelix18
@catfelix18 3 года назад
@@VBAA2Z Windows 10 Pro 1909; Office 365 64-bit; .NET 4.8. No, I didn't get any errors when installing your API. Thanks for your help.
@VBAA2Z
@VBAA2Z 3 года назад
I'm suspecting this is because of 64-Bit Office. I'll try it out over the weekend with 64-Bit and let you know.
@VBAA2Z
@VBAA2Z 3 года назад
Please try this latest version tested for windows 10 64bit office and share your observations. bit.ly/googleapisvba102
@philcraig2893
@philcraig2893 3 года назад
Is there a limit on how many folders/subfolders can be created at a time?
@VBAA2Z
@VBAA2Z 3 года назад
I think you can send unto 1000 requests within a sec. Check out pinned comment for more info on Quota
@charlesdawnbeltran9603
@charlesdawnbeltran9603 3 года назад
Can we store MSAccess in google drive and perform CRUD using Excel VBA?
@VBAA2Z
@VBAA2Z 3 года назад
No we cannot without API. Another way would be to install google drive app in system, enable sync, access google drive in windows like any other folder. Hope it helps. If it helps do not forget to support the channel :) Cheers!
@charlesdawnbeltran9603
@charlesdawnbeltran9603 3 года назад
Is there an API to do it to enable multiple user?
@nortexlubetune8144
@nortexlubetune8144 3 года назад
how did you get the setup file or the .msi file? I cannot find them anywhere
@VBAA2Z
@VBAA2Z 3 года назад
Please find it in the video description
@user-hz6xx8ze7b
@user-hz6xx8ze7b 2 года назад
How to download GoogleDriveVBA for Excel library?
@VBAA2Z
@VBAA2Z 2 года назад
please check vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@amineelmouatamid9321
@amineelmouatamid9321 3 года назад
Thanks for explication. please from where can I download GoogleDriveVBA.msi
@VBAA2Z
@VBAA2Z 3 года назад
you're most welcome. Please check video description for the link.
@user-qi7uo2eq6d
@user-qi7uo2eq6d 3 года назад
Thank you for your great video. I like to ask where to download the setup.ex.e (googledrivevba setup wizard)
@VBAA2Z
@VBAA2Z 3 года назад
please check below here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html 021 GoogleapisVBA (free version) - VBA library for Google Sheets and Drive
@user-qi7uo2eq6d
@user-qi7uo2eq6d 3 года назад
@@VBAA2Z Thank you for the rapid reply. Already requested. May you advise that where can I download the dll file / tlb file in Google.com. So I can keep track if there is any update or look for more reference topic to read.
@VBAA2Z
@VBAA2Z 3 года назад
I developed this library, once updates are available it'll be published here.
@user-qi7uo2eq6d
@user-qi7uo2eq6d 3 года назад
@@VBAA2Z Understood. I am looking forward to receive your email. Thank you.
@VBAA2Z
@VBAA2Z 3 года назад
@@user-qi7uo2eq6d sent. be sure to check spam folder too.
@bhaskarroy3364
@bhaskarroy3364 2 года назад
how to download Google APIs VBA or the setup.exe. I cannot find it anywhere. Please help. This is where the video just snaps for me, sorry.
@VBAA2Z
@VBAA2Z 2 года назад
please check vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@migueldacosta1778
@migueldacosta1778 3 года назад
Thank you for the information, but where is the program to download which you reference in your video?
@VBAA2Z
@VBAA2Z 3 года назад
Please free section from this link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@migueldacosta1778
@migueldacosta1778 3 года назад
@@VBAA2Z do I need to fill out the request form?
@migueldacosta1778
@migueldacosta1778 3 года назад
@@VBAA2Z I have requested the file from your site, project 021 I believe. waiting for your response. thank you
@VBAA2Z
@VBAA2Z 3 года назад
you're welcome! sent.
@migueldacosta1778
@migueldacosta1778 3 года назад
@@VBAA2Z thanks but I have not received anything
@user-pb7zf8tm3x
@user-pb7zf8tm3x 2 года назад
Where can I purchase the source codes and library about this video?
@VBAA2Z
@VBAA2Z 2 года назад
Please check options here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@user-dp5xg7wf2b
@user-dp5xg7wf2b 6 месяцев назад
Waiting for new videos
@VBAA2Z
@VBAA2Z 6 месяцев назад
Very soon
@jarod9856
@jarod9856 3 года назад
I have a question: Where can i find GoogleApiVBA library?
@VBAA2Z
@VBAA2Z 3 года назад
Please follow this link. If you've already requested please be sure to check spam folder too. vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@sasikumar8881
@sasikumar8881 3 года назад
If i try to run this macro following error is coming Authorization Error Error 403: access_denied I had followed each and every step as you mentioned in this video still cannot able to execute
@VBAA2Z
@VBAA2Z 3 года назад
Make sure your Google Cloud Platform (GCP) is published or you can add emailed as test user. Make sure the GCP credential you're using to connect have access the object in drive/sheet.
@sasikumar8881
@sasikumar8881 3 года назад
@@VBAA2Z Thanks for the information now it has started working fine. I have few queries can u pls clarify it 1) In the list macro only 100 files are captured and displayed in excel but i have many files in my drive. 2) In the same macro, will it display the shared files as well ? Thanks in Advance.
@VBAA2Z
@VBAA2Z 3 года назад
Glad to hear it worked fine. -In free version there are few limitations and can list 100 items. -It'll list all files the requesting user has.
@Giuseppe_7_
@Giuseppe_7_ Год назад
i'm sorry if this is a stupid question but how can I download my project?
@VBAA2Z
@VBAA2Z Год назад
please check pamaitech.com/downloads/
@mrv601
@mrv601 3 года назад
Hi Pamai! Many thanks for awesome content. Every time I run the Sub 'SetInfo' and others with the GoogleapisVBA I get Run-time error '-2147221164 (80040154)' "Class not registered". I have Excel 2019 MSO 16.0.13127.20402 x64 & Win10 Pro 1909. As for the .net 4.7.2 it says ".NET Framework 4.7.2 or a later update is already installed on this computer. " I install the one for developers with no success.
@VBAA2Z
@VBAA2Z 3 года назад
I'm suspecting this is because of 64-Bit Office. I'll try it out over the weekend with 64-Bit and let you know.
@mrv601
@mrv601 3 года назад
@@VBAA2Z Thank you
@VBAA2Z
@VBAA2Z 3 года назад
Please try this latest version tested for windows 10 64bit office and share your observations. bit.ly/googleapisvba102
@BestFriendsForeverTrue
@BestFriendsForeverTrue 4 года назад
Can you show video how to protect vba code in excel and anyone can't break it?
@VBAA2Z
@VBAA2Z 4 года назад
Follow the VSTO Series. It will guide you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KPSuvRSwgh4.html
@VBAA2Z
@VBAA2Z 4 года назад
Or just Protect Excel Workbook :)
@rocherto
@rocherto Год назад
There's no option to purchase it, Is there any other option to get it?
@VBAA2Z
@VBAA2Z Год назад
please refer to 'GoogleApisVBA Premium Subscription' section from below link. vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@cyberblitz
@cyberblitz 3 года назад
Where do you get the GoogleDriveVBA.msi file from?
@VBAA2Z
@VBAA2Z 3 года назад
vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@timandrews8641
@timandrews8641 3 года назад
Hey, Great Video. I am hung up at creating the test folder. Why am I getting the following error: Error 403: access_denied The developer hasn’t given you access to this app. It’s currently being tested and it hasn’t been verified by Google. If you think you should have access, contact the developer
@VBAA2Z
@VBAA2Z 3 года назад
from your cloud project either 1 - Publish it. Can ne found under OAuth consent screen 2 - Add your email ID as user to test the project.
@timandrews8641
@timandrews8641 3 года назад
@@VBAA2Z Thank you, thank you, thank you!! I am new to VBA, and API's so I might have a few more questions. Thanks again! you made my day
@VBAA2Z
@VBAA2Z 3 года назад
No probs. Glad to hear that.
@user-dl9lz8zr4g
@user-dl9lz8zr4g 10 месяцев назад
Where can i download the library?
@VBAA2Z
@VBAA2Z 10 месяцев назад
please order from here pamaitech.com/downloads/
@hellsingultimate4007
@hellsingultimate4007 3 года назад
how to download the source code? It's seems great.
@VBAA2Z
@VBAA2Z 3 года назад
Hellsing Ultimate, thanks for watching. Check out the below videos. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PkQ5g8oOQ_4.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IZj5P2j8Oyo.html
@bholanathbiswas3191
@bholanathbiswas3191 2 года назад
how to download this program
@VBAA2Z
@VBAA2Z 2 года назад
please check here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@arnodorian1553
@arnodorian1553 4 года назад
Is it possible with dropbox ?
@VBAA2Z
@VBAA2Z 4 года назад
This library is designed specifically for Google Drive only however DropBox also allows APIs so similar program can be designed.
@arnodorian1553
@arnodorian1553 4 года назад
It would be really helpful if you could share some guide if you have knowledge for this.
@VBAA2Z
@VBAA2Z 4 года назад
Here few examples to list, upload and download from DropBox. www.dropbox.com/developers/documentation/dotnet#tutorial
@arnodorian1553
@arnodorian1553 4 года назад
Thank you man, keep up the good work ❤
@Roberto-ui6nc
@Roberto-ui6nc 3 месяца назад
Hello, my name is Roberto, I am a student. First of all, thank you for the videos, I wrote to you because I need your help, please send you an email, if you would be so kind I would like you to read it. Thank you
@VBAA2Z
@VBAA2Z 3 месяца назад
I will check it out
Далее
skibidi toilet zombie universe 37 ( New Virus)
03:02
Просмотров 1,9 млн
СМОТРИМ YOUTUBE В МАЙНКРАФТЕ
00:34
Просмотров 977 тыс.
Integrate Excel, VBA and SQL. Simplified and powerful
1:01:23
VBA to List files and folder in Google Drive
9:12
Просмотров 2,2 тыс.
Upload/Export Data To Google Sheets Excel VBA Macro
10:57
КРУТОЙ ТЕЛЕФОН
0:16
Просмотров 7 млн