I need VBA code to upload file on google drive

[joedhk]

Hi, does any one know how to upload file from PC to Google drive using VBA code.If any one have any idea please share.Thank you.

 

[Ruddles]

Have you tried doing it manually with the Record Macro option enabled, then examining the recorded code to pick out the relevant commands?

That's how I found out how to upload a file to Microsoft OneDrive.

 

[joedhk]

Have you tried doing it manually with the Record Macro option enabled, then examining the recorded code to pick out the relevant commands?

That's how I found out how to upload a file to Microsoft OneDrive.

Hi, I have tried that and it is not working for me.

 

[Ruddles]

Could you post the code here?

 

[joedhk]

Could you post the code here?

Hi,I have tried that.macro didn't recorded any code.

 

[nguyendang]

Hi, does any one know how to upload file from PC to Google drive using VBA code.If any one have any idea please share.Thank you.

You need to implement Google Drive API.
Unfortunately, Google does not provide any client library for VBA, so I have written one on my own.
For example, design a simple userform that:

• Uploads/download file.
• Lists all Google Drive files in tree view.

GoogleDriveAPI.xlam

 

[joedhk]

You need to implement Google Drive API.
Unfortunately, Google does not provide any client library for VBA, so I have written one on my own.
For example, design a simple userform that:

• Uploads/download file.
• Lists all Google Drive files in tree view.

View attachment 87660

GoogleDriveAPI.xlam

Hi, your shared file no longer exist. can you upload it again please.

 

[nguyendang]

Hi, your shared file no longer exist. can you upload it again please.

I re-uploaded the .xlam file as you requested.
GoogleDriveAPI.xlam

 

[joedhk]

I re-uploaded the .xlam file as you requested.
GoogleDriveAPI.xlam

Hi. which version of excel you used to build this Macro? I am getting this error to open it. I am using office 2013.

 

[joedhk]

I am using 64 bit windows 10 OS.