winzip icon

Integrate Google Drive into VBA applications

Submitted on: 9/2/2015 1:16:16 AM
By: Dang Dinh Ngoc 
Level: Beginner
User Rating: By 1 Users
Compatibility: VB 6.0, VBA MS Access, VBA MS Excel
Views: 17072
     Allow simple user to interact with Google Drive objects using VBA code. Since there was not much resource assisting VBA's interaction with Google APIs, thanks to Kyle Beachill, Bruce Mc Pherson and Tim Hall at Inspired from their code on OAuth2, I decided to copy, past stuff around the Net and put into this small Access Application to demonstrate the VBA interaction with Google Drive Apis. I hope this would be of help for whom of interst. The application is written in Vietnamese but comments are made in English. Also, I used zlib class, Json class from some other authors. (My original idea was using rclone with access but finally I don't need them. You can also file the old version using shell and rcclone here Hope you would enjoy this.
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
  3. Scan the source code with Minnow's Project Scanner

If you don't have a virus scanner, you can get one at many places on the net

Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Beginner category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)

Other User Comments

9/3/2015 8:10:47 AMDang Dinh Ngoc

The updated link for this application can be reached at
(If this comment was disrespectful, please report it.)

1/6/2016 2:44:28 PMififthelement

website< /span> not accessible from india
(If this comment was disrespectful, please report it.)

1/25/2016 3:34:33 PMDang Dinh Ngoc

So please send me an email then I would send the file to you directly.
skype: paulsteigel
(If this comment was disrespectful, please report it.)

6/26/2016 5:59:10 AMryancurrah

Hi there, is there any way to adapt this to work with excel?
(If this comment was disrespectful, please report it.)

3/18/2017 1:21:19 PMDang Dinh Ngoc

Sure it can be done with any app using vb6!
(If this comment was disrespectful, please report it.)

2/14/2018 5:43:03 AMJim

I tried your sample db and replaced your credentials with mine. However, when I click on "Get new Token," I get an "Invalid use of Null" error and the debugger takes me to this line:

If .LoginGoogle(txtGAccount, txtGPassword) Then

Floating over the variables, they do contain my account email and my password.

Have there been changes to the API that broke your db?

Thank you!
(If this comment was disrespectful, please report it.)

6/14/2019 9:12:29 PMRaul

After replaced your credentials with mine, and I clicked on "Get Token" shows me:

Run-time Error '483'

Object doesn't support this property or method

line: .LogOnGoogle txtGAccount, txtGPassword

What do you suggest that can be the issue..!!

Is this code works in 2019?

Thanks in advance.
(If this comment was disrespectful, please report it.)


Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)

To post feedback, first please login.