Excel VBA Connection With Google Drive

[wiseowlexcel]

[FONT=&quot]Hellow Experts,[/FONT]

[FONT=&quot]Please kindly guide if there is some way that we can upload file to Google Drive Directly like CDO email.[/FONT]

[FONT=&quot]Regards,[/FONT]

 

[John_w]

This can be done with Excel VBA and XMLhttpRequest to send requests to the Google Drive API - https://developers.google.com/drive/v3/web/manage-uploads

You first have to enable the Google Drive API in the Google API Console within your Google account, and then register your application (the VBA program) and generate Client ID and Client Secret strings which are then used by your code.

The code also has to handle an IE window which asks your user to give permission to use the API.

 

[John_w]

As per the Forum Rule number 13, please post links to your cross-posts.