Javascript required
Skip to content Skip to sidebar Skip to footer

Can You Upload a Document With Macros to Google Drive

#1

Upload file to google drive

Howdy 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

< ----- Please click the little star * next to add reputation if my post helps y'all
Visit Forum : From Here


#2

Re: Upload file to google drive

Possibly this will help:
Regards, TMS

Trevor Shuttleworth - Excel Assist

I dream of a better earth where chickens tin can cross the road without having their motives questioned

'Existence unapologetic means never having to say you're sorry' John Cooper Clarke


#3

Re: Upload file to google drive

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

However, the principle is the aforementioned. Get the location of the Documents folder, edit it and change information technology to Google Drive. And so go the current workbook's file name and edit as required. If you lot want to salve a copy of the .xlsm file, there's less to do and just utilise SaveCopyAs

Regards, TMS


#4

Re: Upload file to google bulldoze

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 demand to upload whatever type of file to it
Thanks very much

#5

Re: Upload file to google drive

You're welcome.

If y'all are satisfied with the solution(southward) provided, please mark your thread as Solved.

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

Or you can use this mode:

How to mark a thread Solved
Get to the first post
Click edit
Click Go Advanced
Simply below the discussion Title you lot will see a dropdown with the word No prefix.
Change to Solved
Click Relieve

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


#six

Re: Upload file to google drive

Thanks for the instructions but information technology is yet unsolved for me..
I demand to save or upload file to google drive

#7

Re: Upload file to google drive

Whatsoever help with this topic?

#8

Re: Upload file to google drive

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

#9

Re: Upload file to google drive

Thanks a lot for answer
I only demand to copy whatsoever extension (any file with any extension) to Google Bulldoze on my account ..as a kind of backup for my files
If the file is already existed on Google Drive >> and so the lawmaking to overwrite the old one afterward alert bulletin
Thanks avant-garde

#10

Re: Upload file to google drive

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

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


#xi

SadieLynn is offline

Registered User


Re: Upload file to google drive

Quote Originally Posted past TMS View Post

Maybe this will help:

Regards, TMS

-- So I edited this code to lucifer for my google drive- I ran the code and it did non give whatever errors, but information technology is not showing the saved file in my google drive folder.. tin you please recommend a solution?

Thank y'all!


connellthimeftes.blogspot.com

Source: https://www.excelforum.com/excel-programming-vba-macros/1111143-upload-file-to-google-drive.html