Setting Microsoft Office 2012 Trust Center's Trusted Location Paths using Powershell.

Hi Everyone.

If you are working in a Telecom Industry, and if your Analysts and Consultants are using in house built templates then i am sure that you are 98% facing the “Trust Centre warning”.

We are using custom in house built Office Templates for Word,Excel, and PowerPoint.  and the problem was whenever we open our in house templates is Office 2012 we were facing the below error.

We can click on it but it is a quite annoying.



To resolved this error, the solution is to add our custom built templates directory to the  trusted location in trust center manually on every laptop and desktop.



Did i mentioned MANUALLY???

Naaaaaa !!!!!!! I thought that we can script this.

And to resolve this is wrote a simple script. you can download the script from this link :
http://gallery.technet.microsoft.com/scriptcenter/Setting-office-2010-31d6a5f4

This script is very simple.,

You only need to provide the path of your templates or the location which you want to add as trusted to  $trustlocation variable.

$trustlocation = 'C:\Mylocation\Templates'

and that’s all , when you run the script , the script will create a location registry  named as “Location99” in to the registry.

and the Registry Keys will be look like this .

and i have added comments in the script for easy understanding,

Functionality.

1. First script test the path of the “Location99” registry key
2. and if the Test path fails that will create a New Registry  Folder “Location99” and the the following registry keys
   • AllowSubfolders this is DWORD registry key and the value is 1 to allow subfolders as a trusted location too.
   • Date  = Date of creation
   • Description = Description for location etc.
   • Path  =  Path to the folder
3. and if folder found it just write a confirmation message in the console that folder do exists.
4. The script will do the same process for WORD,EXCEL and Powerpoint.

After running the script the location is added to the Word.

download the script from this link : http://gallery.technet.microsoft.com/scriptcenter/Setting-office-2010-31d6a5f4

Thanks

Aman Dhally

  

How to create and change “Windows Registry Keys” using PowerShell.

 

Hi,

The Best thing about PowerShell is that you can manipulate “windows  Registry Keys” very easily with it. How? Let me show to you.

Why we need to create a registry Hive/key manually?

Actually for lots of reason, for example if you want to install some particular software on all accounting computer automatically and then you can need write a script which check the predefined registry Keys and if it found that the in key  Department is “accounts” then install it may install some accounting software on it otherwise don’t do anything.

Cmdlets used: New-Item , New-ItemProperty, Set-ItemProperty

Before running the below command  make sure you run PowerShell as Administrator.

How to run PowerShell as Administrator?

to do this , Search for PowerShell { you can also access the same from Start > All Programs > Accessories > windows PowerShell > Windows PowerShell} , Right Click on it and Choose “Run as Administrator”

When you run PowerShell as Administrator you will see that the title bar of PowerShell windows shows Administrator:

Now let’s create a new Folder named “CompanyName” in “Hkey_Local_machine” and  beneath Software key folder.

In PowerShell we can use Registry hives as Local drives so we can use New-item cmdlet to create a new registry hive.

new-Item -Name "CompanyName"  -Path 'hklm:\SOFTWARE\'  -type Directory

New-Item : used to create a new folder for file

-Name : Name of the Folder

-Path: where we want to create a new folder

-Type: Directory in our case because “CompanyName” will contain some sub registry keys.

Let’s  check . . . Yes “Registry Hive” is created . .

now lets create a new Registry key in “ComanyName”  names as “Department” which have some information about which on Department the laptop/desktop belong to.

New-ItemProperty -Path 'hklm:\software\CompanyName\' -Name "Department" -Value "I.T"

Let’s check ….. Key is created . . . .

okies..

what if you need to change the value of the key?, you can do it easily using Set-ItemProperty cmdlet.

Now Lets change the department name from “I.T.” to “Accounts”

set-ItemProperty -Path 'hklm:\software\CompanyName\' -Name "Department" -Value "Accounts"

 

Let’ See…….yes Department name is changes from “I.T.” to “Accounts”

 

I hope this post will save someone time :) ..

Thanks

Aman Dhally

www.amandhally.net/blog