winzip icon

Integrate Google Drive into VBA applications

Email
Submitted on: 9/2/2015 1:16:16 AM
By: Dang Dinh Ngoc 
Level: Beginner
User Rating: Unrated
Compatibility: VB 6.0, VBA MS Access, VBA MS Excel
Views: 9846
 
     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 http://ramblings.mcpher.com/Home/excelquirks/guests/oauth2. 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 http://www.sfdp.net/thuthuataccess/demo/democAuth_old.rar?attredirects=0&d=1) 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 including:McAfee.com


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
http://www.sfdp.net/thuthuataccess/demo/democAuth.rar?attredirects=0&d=1
(If this comment was disrespectful, please report it.)

 
1/6/2016 2:44:28 PMififthelement

http://www.sfdp.net/thuthuataccess/demo/democAuth.rar?attredirects=0&d=1

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.
Ngoc
ngocdd@sfdp.net
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.)

 

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.