Powershell Script : Get the file and Product version of Ms office Applications.

Hi,

I hope you guys are doing good.

My last two months were very busy, that why i was not able to post any article. I apologize for that.
Last week Microsoft has release few mandatory ms office update.

That update was crucial for outlook users, before apply ms office updates, we need to know, which outlook version and build my users are using.

To achieve it, i have written a tiny “Powershell” script. when you run the script, that will give you the file version and product version information of WORD, EXCEL, POWERPOINT and outlook.



Download Link : http://gallery.technet.microsoft.com/scriptcenter/Get-Offie-Applications-5c0bb2e1

I tested this script on “office 2010 32 bit” on windows 7 32 bit.
I hope you may like the script and found it helpful.

Thanks

Aman Dhally

   

Alias and Powershell profiles

 

Hi All

I love “RUN” box.  We can open run box “Windows Key + R” and type the Excel, Powerpoint, and click on OK and its open these application which are in the System path.

But if you try to run “Excel” or “Powerpoint” etc in PowerShell console they wont work.

Everyday i open firefox, Internet Explorer, Ms Word, Ms Excel, Ms PowerPoint from “RUN” box. but today i thought that these application must me run from my powershell console.

The benefit of this is that i don't need to open “RUN” box every time before running any command.

Windows PowerShell Profile

First we need to create a windows powershell profile. It is a simple .ps1 file which reside on your Document folder and it run before opening PowerShell console.

Now open PowerShell Console and in Console type notepad $profile

If you don’t have profile created before it ask you to create a new file. Click on Yes.

First i want that whenever I open “PowerShell” console it should run in “D:\PowerShell”, to achieve this we need to use Set-Location cmdlet.

Set-location D:\PowerShell

Now save the file and close it. and lets open PowerShell Console again.

Cool!!! now the default path of PowerShell console is set to “D:\PowerShell”

Aliases

Our Next Step is to setup alias. to achieve this we are using  Set-Alias .

The Syntax to setup alias is Set-Alias <Name> <Path of file >

We are setting up alias for Word,Excel,Powerpnt,Outlook,Firefox,Internet,Explorer,Chrome,

and the command should be : 

Note: I am using Office 2010 and may be your office path may be different.

 

Set-Alias word        'C:\Program Files\Microsoft Office\Office14\WINWORD.EXE'

Set-Alias powerpnt   'C:\Program Files\Microsoft Office\Office14\POWERPNT.EXE'

Set-Alias excel      'C:\Program Files\Microsoft Office\Office14\EXCEL.EXE'

Set-Alias outlook    'C:\Program Files\Microsoft Office\Office14\OUTLOOK.EXE'

Set-Alias firefox    'C:\Program Files\Mozilla Firefox\firefox.exe'

Set-Alias Iexplore   'C:\Program Files\Internet Explorer\iexplore.exe'

Set-Alias Chrome     'C:\Users\aman.dhally\AppData\Local\Google\Chrome\Application\chrome.exe'

now open our powershell profile again and paste the above command.

save the file and close it. and also close the PowerShell console and open it again.

Lets test it now

- Excel => Working

- Word => Working

- PowerPoint => Working

- Outlook => Working

Our all Ms Office applications are working .. lets test browsers now.

- Chrome => Working

- Firefox => Working

- Internet Explorer => Working

All is working .. u can add more alias if you want.

Thanks

Aman Dhally