How can I always know the exact path to Excel.exe?

[hollifd]

I have asked this same question on the Access board. I hope I am not violating any forum rules.

If I wanted to open Excel.exe on a user's machine, how can I know the exact path to the Excel.exe file.

I want to open Excel.exe from a batch file like:

C:\Program Files\Microsoft Office\Office11\Excel.exe

but the path may be different for some users. It could be Office10 or some other difference.

What VBA code can I use in order to always know the correct path to the latest version of Excel or Access?

Thanks,

David

 

[hatman]

if I mis-remember, you should be able to simply enter a command of

shell excel.exe

Theoretically, the location of the exceutable is "pathed" so it is equivalent to the "Root directory". An example, here are all of the directories that are "Pathed" on my machine... notice that the directory containg excel is in the list (actually first in the list):

Path=C:\Program Files\Microsoft Office\OFFICE11\;C:\Program Files\CA\Dcs\DMScripting\;C:\Program Files\CA\DCS\CAWIN\;C:\Program Files\Intel\Fortran\compiler80\IA32\BIN;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\Program Files\Bin;C:\Program Files\Winzip;C:\WINDOWS\SYSTEM32\WBEM;K:\PROD\Share\Bin;K:\PROD\WNT\Bin;C:\Oracle\920\bin;C:\Oracle\920\jre\1.4.2\bin\client;C:\Oracle\920\jre\1.4.2\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\SYSMGT\CA_APPSW\VIRUSSCAN;C:\SYSMGT\TNGEAV;C:\Oracle\EIS\BIN;C:\Oracle\EIS\jdk\bin;C:\Program Files\IBM\Client Access;C:\Program Files\IBM\Client Access\Shared;C:\Program Files\IBM\Client Access\Emulator;C:\Program Files\STRATEGY\bin;K:\PROD\WNT\LIB;C:\PERL\V58\bin;C:\SYSMGT\TNGSD\BIN;C:\Program Files\CA\SharedComponents\CAM\bin;C:\Program Files\Hummingbird\Connectivity\7.10\Accessories\

 

[hollifd]

Thanks hatman,

That is a very funny picture. I get a chuckle every time I look at it.

My problem is much bigger than I originally stated. I am currently working with Norie on the Access forum to try to solve my bigger problem. Thanks for the reply.

David