Excel Path

[Carlos]

I want to read out the path where excel is installed.

Is this possible?

[JerryD]

With Office 2003, the default value of the key "HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\edit\command" has the full path to Excel. The entry is actually "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e, so you'd need to strip out the quotes and the trailing /e like this:

$ExcelPath = RegRead ( 'HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\edit\command', '' )
If StringLeft ( $ExcelPath, 1 ) = '"' Then
    $ExcelPath = StringTrimLeft($ExcelPath,1)
EndIf
$ExcelPath = StringTrimRight( $ExcelPath, StringLen($ExcelPath)-StringInStr($ExcelPath,'"',1)+1 )
MsgBox ( 0, @ScriptName, $ExcelPath )

[weaponx]

JerryD - Good solution for certain versions of Office

Unfortunately mine doesn't have command line parameters.

This is more fool proof.

;Returns path with trailing backslash
$excelFolder = RegRead ( "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe", "Path" )
If StringRight($excelFolder, 1) <> "\" Then $excelFolder &= "\"
$excelPath = $excelFolder & "excel.exe"

Edited December 7, 2007 by weaponx

[JerryD]

You're absolutely right! App Paths is EXACTLY where to check. I stand corrected.