Add Dropbox and Google Drive as locations in Office 2013

UPDATE: A new version of this can be found HERE!

The full article and script can be found here at Technet.

Scenario

Both Dropbox and Google Drive have become more popular to share files with others and to keep an extra copy of documents, pictures and so on.
This Powershell script will add your Dropbox and Google drive folders as save locations in Microsoft Office 2013, directly under Save, Save As and Open.
Click to enlarge

Script

Step 1: Start with opening a Powershell as administrator and type the following command Import-Module <path to script>, and press enter.
Click to enlarge

Step 2: To see a list of all commands and to get help on syntax, parameters and to see some examples, type Get-Help New-SaveLocation -Full
Click to enlarge

Example
To add shortcuts for both Dropbox and Google Drive, simply type “New-SaveLocation” and press “Enter“.
In the Powershell you will see the keys added to registry, and if something wen’t wrong during writing.

To add a single shortcut, Dropbox or Google Drive, type one of the following commands and press “Enter

  • New-SaveLocation -GdriveShortcut
  • New-SaveLocation -DropboxShortcut

Click to enlarge

What it does

The script will assume that Dropbox and/or Google drive has been installed at it’s default location.
If this has been changed, you will be asked to enter the path to the folder.

In Office 2013

In Office 2013, you need to add the added folder/folders to your account.
To do this, simply open Word and go to either Open, Save or Save As. Then click on “Add a Place” and once more on the corresponding folder/folders to add them.

Click to enlarge

Sample code (Download to get the full code)

#Ask for input if folder can't be found in default location 
If(!(Test-Path -Path "$($gdrivedir)")) 
{ 
[string]$gdrivedir = Read-Host 'Could not find Google Drive. Enter path to folder manually: ' 
} 

#Add registry values 
New-Item -Path 'HKCU:SoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' 
New-ItemProperty -Path 'HKCU:SoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' -Name DisplayName -PropertyType String -Value 'Dropbox' 
New-ItemProperty -Path 'HKCU:SoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' -Name Description -PropertyType String -Value 'Dropbox is a free service that lets you bring all your photos, docs, and videos anywhere.'
This entry was posted in Powershell, Windows 8 and tagged , , , , . Bookmark the permalink.

1 Response to Add Dropbox and Google Drive as locations in Office 2013

Leave a Reply

Your email address will not be published. Required fields are marked *