Download xlsm file from Google Drive

Hi,

I've copied a code from the internet (many sites has the same code, one example is here) then try it but fail.

This is the code :

Please Login or Register  to view this content.

at line WinHttpReq.send, after a few seconds it show an error :

Run-time error '-2147024891 (80070005)':
Access is denied

What I've tried so far :
1. checked that the file in Google Drive has permission "Viewers and commenters can see the option to download, print, and copy"
2. fill the "username", "password" just before line WinHttpReq.send with google username and password

But I still get the same error.

The URL itself, if I paste it in the browser address then the browser download it directly.
What did I do wrong ?

Any kind of help would be greatly appreciated.
Thank you in advanced.

Hi YasserKhalil,

I'm sorry I can't give the URL as it's a company's file where the company gave me the link.

I'm sorry, please never mind the question.
I found a different code from this link and it worked :

Please Login or Register  to view this content.

Thank you.

Ok... I will try that.

Thank you, YasserKhalil

Originally Posted by YasserKhalil

Are you sure the file is downloaded rightly?

With the second code I found in the internet, yes - it downloaded rightly.

.. I tried this with a link and that doesn't work for me ..
I just changed the id part with mine but didn't work..

in my side, it worked seamlessly.

The first code (using "Microsoft.XMLHTTP" object) not work in my side.