VBA and environment variable

[Marcel Nihon]

Hi,
With VBA for Access, how can we retrieve the value of an environment
variable such as %windir% for example?
Thanks is advance.
Marcel

 

[Douglas J. Steele]

Use the Environ function:

Environ("windir")