Here is the way I do it - it's been in production for about 3 years now.
I test for the usual places the various versions of Excel reside.
Active Link 1 (check for Excel 2003)
Run If Qual: nothing
Set Fields
zTmpField1 = "C:\Program Files\Microsoft
Office\OFFICE11\Excel.exe"
Set Fields
zTmpField2 = $PROCESS$ cmd.exe /c "if exist """$zTmpField1$"""
(echo Yes) else (echo No)"
Active Link 2 (not found, check for Excel XP)
Run If Qual: NOT 'zTmpField2' LIKE "Y%" OR 'zTmpField2' = $NULL$
Set Fields
zTmpField1 = "C:\Program Files\Microsoft
Office\OFFICE10\Excel.exe"
Set Fields
zTmpField2 = $PROCESS$ cmd.exe /c "if exist """$zTmpField1$"""
(echo Yes) else (echo No)"
Else Action (means it found it in Active Link 1)
Set Fields
Global - Excel Path = $zTmpField1$
...and so on until you find a match. Right now I only check for Excel
2003, Excel XP, Excel 2000. This reminds me, I need to add a check for
Excel 2007 since several users are beginning to use that version.
There is another option available to you - WksInfo from
http://arswiki.org/projects/dotnetutil. Click on the Downloads link
located in the upper-right part of the screen.
This free open source utility gathers a number of details from the
user's computer (from Windows User Tool, not Mid-Tier) and makes them
available to your workflow. The Excel path is included (although it
needs to be updated to check for Excel 2007).
The utility is written in VB.Net 2005 and the ARS .Net API.
Stephen
Remedy Skilled Professional
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel
Sent: Thursday, January 24, 2008 7:49 AM
To: arslist@ARSLIST.ORG
Subject: Find EXCEL.EXE full path
Hi All,
Can anyone share 'How to get EXCEL.EXE full path from user tool?'
Usually EXCEL.EXE path is
C:\Program Files\Microsoft Office\OFFICE11
Thank you very much,
Daniel Condrea
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
