Solved How can i upload or download a file from Google Drive In VBA ? (1 Viewer)

[VBANewBie :)]

Hi guys , As the title i need to download and upload files directly to google drive with vba code without using synchronize folder as it will be used on different PCs .
Thanks in advance

 

[Gasman]

Google drive has a mapped letter?

 

[VBANewBie :)]

Google drive has a mapped letter?

No , My point is to use API but i don’t know the exact steps nor the right code.

 

[Uncle Gizmo]

upload files directly to google drive with vba code

Is this any Help?

VBA to Upload single or multiple files to Google Drive​

 

[Gasman]

Could have said that in the first post?

No , My point is to use API but i don’t know the exact steps nor the right code.

 

[Gasman]

Is this any Help?

VBA to Upload single or multiple files to Google Drive​

Amazing what a quick Google will find

 

[VBANewBie :)]

VBA to Upload single or multiple files to Google Drive

I think it’s not the complete guide , But i will take a look .
Thanks

Could have said that in the first post?

Sorry Bro my bad .

 

[VBANewBie :)]

Hello again , I got this example and got all the needed credentials but i get this error when it tries to connect to google account , can anyone help ?

these are current references , Any missing ?

Thanks guys

 

[Gasman]

I cannot even open the DB?

Tried again and did manage to get it open. You did not say what to use to get the error

I tried opening FrmGdrive and got

 

[VBANewBie :)]

I cannot even open the DB?

Thanks for reply , I can open it normally in 32-bit office .
The error happens in form settings if you press Get token button like this image

 

[Gasman]

No it tells me it will lose all the modules as the VBA project is corrupt or to that effect.

Get it compiled first then upload again.

 

[VBANewBie :)]

I compiled it with no errors and saved as accdb try it , The both of them work fine

 

[VBANewBie :)]

Decompiled with vbs script then compiled again

 

[The_Doc_Man]

Looking at your Tools >> References exhibit, I suspect part of the problem is that you don't have a Google library checked. I would think that a method as specific as .LogOnGoogle user, password would have to be part of a vendor-specific (i.e. Google) references library, which means you would have to check it in your references list. I would be astounded to find that a .LogOnGoogle method was available from any of the "standard" Access libraries.

 

[theDBguy]

Looking at the sample file, .LogOnGoogle is a method of the gAuth2 class. Maybe the error is actually within that method. Just a thought...

 

[VBANewBie :)]

you don't have a Google library checked

Thanks for your reply , I searched my references and didn’t find any google and also the person who shared the example didn’t mention any special library .
I don’t know what to do

 

[Gasman]

You can create all this code, yet cannot carry out simple debugging?
Ah wait, you didn't create it, just copied it?, but still had to modify to suit, surely?

Your error is here as shown below in LogOnGoogle

You have On Error Goto ErrorHandler in some subs/functions which just exits the sub/function?

How are you meant to determine where any error is?

 

[The_Doc_Man]

After further research, I found this article that names a file you could try to find. It was for another environment, but it seems similar.

Unable to run Google Cloud PubSub in c#, DLL problems

I am working on integrating Google Cloud PubSub into my c# project, I used NuGet to install 1.0.0-beta11, no errors at all. When I run my project and when it reaches the code that uses pubsub, I g...

stackoverflow.com

Otherwise, since you are obviously a cloud-service customer you should be able to call their help desk and ask for the name of (and a source of) the required .DLL file that would satisfy those references.

 

[Gasman]

The code just grinds my laptop to a halt.

Edge opens instead of IE

Even when I know where to put the breakpoint at?

Puzzled as to why I cannot see the objects like olExplorer?

This is beyond my pay grade

 

[VBANewBie :)]

Ah wait, you didn't create it, just copied it?, but still had to modify to suit, surely?

I didn’t mention that i’m an expert or i did write this code , And sure i did my best trying to figure out what’s missing and i suspected it was a missing reference and it probably is .
thanks for your help