Excel save pdf and upload to google drive

[mdavontuur25]

Hi all

I work for a company where the directors are mobile all the time and therefore need info on the go.

I create invoices and quotations at the base office in Cape Town and then have to save these as pdf and then upload them to google drive (the directors' cloud computing system). This can take up a lot of my time and I want to streamline this.
Question: I want to write a macro that will be activated by a button that will do the following:
1) Save my document in PDF format
2) Upload to google drive

NB! we are always logged in to the google drive page.

Thank you in advance for all the help.

 

[wigi]

Hello there

1) For example, to save the active worksheet on the C drive:

ActiveSheet.ExportAsFixedFormat _                    Type:=xlTypePDF, _
                    Filename:="C:\test.pdf", _
                    To:=1, _
                    Quality:=xlQualityStandard, _
                    OpenAfterPublish:=False

2) I am not an exper ton this, even more, I do not know of lot of it
But chances are you need to use an API. See here for example: https://developers.google.com/gdata/

 

[poolhall]

2) I am not an exper ton this, even more, I do not know of lot of it
But chances are you need to use an API. See here for example: https://developers.google.com/gdata/

Google Drive comes as a Windows application and Windows service. All he needs to do is to save a file to a local folder assigned to GD. Google Drive service synchronizes the GD local folders as soon as it detects any changes in them, usually immediately. I started to use GD recently to share some work files with colleagues, and highly recommend it, it's a great stuff.

 

[wigi]

Thank you for the information Poolhall.
So, it seems my macro above should point to that local folder instead of C:\
And it's ready