Link to home
Start Free TrialLog in
Avatar of WiseOwl Excel
WiseOwl ExcelFlag for Pakistan

asked on

Excel VBA Connection With Google Drive

Hellow Experts,

Please kindly guide if there is some way that we can upload file to Google Drive Directly like CDO email.

Regards,
Avatar of Bill Prew
Bill Prew

By far the easiest way is to install the Google Drive windows sync software on your computer.  Once you sign in to your account and set it up, you can just copy files to and from a local path as if it was a normal windows folder.  The default location is "C:\Users\Username\Google Drive" where Username is the computer user name.

https://www.google.com/drive/download/


»bp
You might use their REST API
https://developers.google.com/drive/v2/reference/

In the VBA code, you will probably use the MSXML2 object.
Avatar of WiseOwl Excel

ASKER

Respected Aikimark

Please Guide in Full i dont understand kindly guide with Example if Possible.

Regards,
@Bill Prew Sir,

Thanks for Input i kow this methode but this is not what i am looking for and Post Question. I Need Code to Upload file to Google Drive Driectly without app via VBA if Possible Please input your Expert Comment and Oblige.

Regards,
Direct interface to Google via RESTful API is a much larger undertaking, I can't take that on as part of a question.  There are authentication tokens to be established and used, and JSON strings to be parsed.  All doable, but a lot of code to build as a question answer, for me...

Feels more like a potential Gig...


»bp
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Respected @Aikimark

Thanks For Coding but this Function is Completely not understandable and Usable for me if you kindly let me know how to use it it would be great help.

Regards,
Respected @Bill Prew,

Your Reply seems you have Sour Ability to do it please kindly help me and the community in this regard and help us to upload simple file to google drive via Excel VBA Simple Coding it would be your remarkable help to community at least for myself.

Regards,
Please answer my question about your VBA experience
Basic  To Intermediate Level in  VBA and Still Learning to Advance Concepts.
If you are an intermediate level, you should be able to understand the links and code.  If you aren't at that level, you need to engage someone who can do all the work for you.  Question threads, like this one, assume that the person asking the questions has the ability to test the posted solutions, ask questions about the posted solutions, and evaluate their effectiveness (pick the best one(s)).

Question threads are not a do-my-work-for-me kind of place.
Dear Sir @aikimark,

Thank you for your kind input and Words however i feel these are a bit Rude to me  anyhow i am asking more it dose not mean i have  not give try to Code i checked Link where Access Projects there as i have no command over access also there are some kind of Google APIs Connection and Client ID and Client Secret where to get it ... i already give a try to codes but didn't understand well thats why i ask... i just need some Expert Assistance to Understand this thats why i post Question over Expert-Exchange.Com.

Thanks You for Your Time and Input.

Regards,
If you need more expert assistance, you can try EE Gigs, EE Live, or click the Report Question link and ask for more expert participation.

As Bill Prew already stated, this isn't a trivial process.