Can you help me to build a script which will check the version of excel install using registry and set to open a application report where excel start.

Hi, You can get the version of Office like this $version = Get-WmiObject -Class Win32_Product -Filter "name like 'Microsoft Office Professional%'" | Select-Object -ExpandProperty Version If it's Office 365 you can try $version = Get-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' | Select-Object -ExpandProperty VersionToReport To create a registry value you can use the New-ItemProperty cmdlet $version -match '\d+.\d' $ver = $Matches.Values New-ItemProperty -Path "HKCU:\Software\Microsoft\Office\$ver\Excel\Options" -Name "OPEN" -Value $filename -PropertyType String Best Regards, Ian Xue ============================================ If the Answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Create a powershell script to check what version of excel is install and set a report to open when excel start

Accepted answer

Ian Xue 37,711 Reputation points Microsoft Vendor

2021-04-16T09:42:49.35+00:00
Hi,

You can get the version of Office like this

$version = Get-WmiObject -Class Win32_Product -Filter "name like 'Microsoft Office Professional%'" | Select-Object -ExpandProperty Version

If it's Office 365 you can try

$version = Get-ItemProperty -Path 'HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' | Select-Object -ExpandProperty VersionToReport

To create a registry value you can use the New-ItemProperty cmdlet

$version -match '\d+.\d' $ver = $Matches.Values New-ItemProperty -Path "HKCU:\Software\Microsoft\Office\$ver\Excel\Options" -Name "OPEN" -Value $filename -PropertyType String

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
Fahad Noaman 171 Reputation points

2021-04-16T10:16:34.197+00:00

Hello Lan Xue,

Thanks for the prompt help.

we use 0365 product.

I belive this script will not detect x64 bit registry.

"HKLM:Software\Wow6432Node\Microsoft\Office\11.0\Excel"

can you help me to create a check like this.

"HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration' or this "HKLM:Software\Wow6432Node\Microsoft\Office\version\Excel"

Ian Xue 37,711 Reputation points Microsoft Vendor

2021-04-19T06:58:03.477+00:00

"HKLM:\Software\Wow6432Node" is for 32-bit applications that run on a 64-bit version of Windows.

Fahad Noaman 171 Reputation points

2021-04-19T07:36:48.627+00:00

can you help me check for 32 bit as well..if in case we have any machine running office with 32 bit

Ian Xue 37,711 Reputation points Microsoft Vendor

2021-04-19T09:55:36.06+00:00

You should still check "HKLM:\SOFTWARE\Microsoft\Office\ClickToRun\Configuration" if the Office 365 is 32-bit.

Fahad Noaman 171 Reputation points

2021-04-19T11:12:16.83+00:00

Thank you so much LanXue.

Really appreciate your help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Create a powershell script to check what version of excel is install and set a report to open when excel start

0 additional answers

Your answer