Upload file to google drive

Hello everyone
I need a VBA macro that would enable me to upload a file to google drive..
Thanks a lot for all great help I receive in this wonderful forum

Maybe this will help:

Please Login or Register  to view this content.

Regards, TMS

Forgot to say, that creates a pdf file in the Google Drive.

However, the principle is the same. Get the location of the Documents folder, edit it and change it to Google Drive. Then get the current workbook's file name and edit as required. If you want to save a copy of the .xlsm file, there's less to do and just use SaveCopyAs

Regards, TMS

Thanks a lot Mr. Trevor
I didn't notice how to upload specific file to google drive .. I have a gmail account and there is Drive in google .. I need to upload any type of file to it
Thank you very much

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thanks for the instructions but it is still unsolved for me..
I need to save or upload file to google drive

Any help with this topic?

What are you trying to save to Google Drive? The current file? Do you want to use SaveAs, or do you want to use SaveCopyAs? Or is it another Excel file? If it is another Excel file, is it open? And would you want to use SaveAs, or do you want to use SaveCopyAs? Or, if it is another file, of whatever type, where is it? And what type of file is it? So you'd need to locate it and copy it to the drive.

Thanks a lot for reply
I just need to copy any extension (any file with any extension) to Google Drive on my account ..as a kind of backup for my files
If the file is already existed on Google Drive >> so the code to overwrite the old one after alert message
Thanks advanced

Well, I've explained how I determine the Google Drive location.

Follow this link to cover copying files: http://www.rondebruin.nl/win/s3/win026.htm