Excel save pdf and upload to google drive

mdavontuur25

New Member
Joined
May 5, 2011
Messages
11
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.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Hello there

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

Code:
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

Active Member
Joined
Jan 9, 2009
Messages
350
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

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,608
Messages
5,597,143
Members
414,129
Latest member
mr vba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top