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
Re: Find EXCEL.EXE full path
Hi Daniel You could try an OLE action using the Windows Script Host Shell Object to do a RegRead on the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, January 24, 2008 12:49 PM 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
Re: Find EXCEL.EXE full path
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
Re: Find EXCEL.EXE full path
Hi David, Thank you very much for your support. Can you help me to figure out what is erong in the registry path because I get the error: Invalid root in registry key . I am using HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe\Path Thank you very much, Daniel Condrea -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Thursday, January 24, 2008 3:04 PM To: arslist@ARSLIST.ORG Subject: Re: Find EXCEL.EXE full path Hi Daniel You could try an OLE action using the Windows Script Host Shell Object to do a RegRead on the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, January 24, 2008 12:49 PM 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Find EXCEL.EXE full path
Hi Daniel You could go to Start menu... Run and type in regedit then browse the registry to see if the key exists?? HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, January 24, 2008 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Find EXCEL.EXE full path Hi David, Thank you very much for your support. Can you help me to figure out what is erong in the registry path because I get the error: Invalid root in registry key . I am using HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe\Path Thank you very much, Daniel Condrea -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders Sent: Thursday, January 24, 2008 3:04 PM To: arslist@ARSLIST.ORG Subject: Re: Find EXCEL.EXE full path Hi Daniel You could try an OLE action using the Windows Script Host Shell Object to do a RegRead on the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\excel.exe HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, January 24, 2008 12:49 PM 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 ___ 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
