Enviroment Variable for Office Install Path?

[Melagan]

As the subject says...does anyone know if there is some kind of stored variable for the install path of Office?

I am distributing shortcuts to users on my network, some of which are on Office 2k and others on Office 2k3. The shortcut will be launching msaccess.exe with a /wrkgrp command switch. The problem is that the O2k install path is "\\Microsoft Office\Office" and the install path for O2k3 is "\\Microsoft Office\Office11"

Something like: Target = "%OFFICEINSTALL%\msaccess.exe" would be awesome. Any ideas? Thanks!


~Melagan
______
"It's never too late to become what you might have been.

 

[TonyJollans]

Try Application.Path

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Melagan]

I'm looking for more of an environment variable to use in a shortcut. I'm not sure how I could use application.path in a shortcut's target box =)





~Melagan
______
"It's never too late to become what you might have been.

 

[TonyJollans]

Hi Melagan,

Sorry, I misunderstood what you were after.

AFAIK, there isn't one by default. However, if I type "msaccess.exe" in the Start > Run box, it runs, so Windows must know how to find it without me having to tell it.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Melagan]

Aye, it must be because "msaccess.exe" is in your PATH environment variable....thats actually not a bad thing to realize. I'll play around with that idea =)



~Melagan
______
"It's never too late to become what you might have been.