Operating System

[Anonymous]

Hi All,

Is there a way to get the installation path of the windows operating system
in VBA?

TIA,

Rob

[Anonymous]

Dim objFileSys As FileSystemObject
Set objFileSys = New FileSystemObject
objFileSys.GetSpecialFolder(WindowsFolder)

... or the API function GetWindowsDirectory

Declare Function GetWindowsDirectory Lib "kernel32" Alias
"GetWindowsDirectoryA" (ByVal lpBuffer As String, ByVal nSize As Long) As
Long

"Rob Outman" wrote in message
news:1EE71DA5FFE19948BA0DBE5BD83111D8@in.WebX.maYIadrTaRb...
> Hi All,
>
> Is there a way to get the installation path of the windows operating
system
> in VBA?
>
> TIA,
>
> Rob
>
>

[Anonymous]

Rob Outman had this to say:

> Is there a way to get the installation path of the windows operating
> system in VBA?

Environ$("WINDIR")

--
There are 10 kinds of people:
Those who understand binary and those who don't
http://www.acadx.com
http://vbxtender.sourceforge.net

[Anonymous]

Thanx again guys...

I have an extra chair next to my desk... would you guys mind taking turns
occupying it for the next couple of years...?

Rob

"Frank Oquendo" wrote in message
news:49773B66505BBA45CBCBFCC8017FAD6C@in.WebX.maYIadrTaRb...
> Rob Outman had this to say:
>
> > Is there a way to get the installation path of the windows operating
> > system in VBA?
>
> Environ$("WINDIR")
>
> --
> There are 10 kinds of people:
> Those who understand binary and those who don't
> http://www.acadx.com
> http://vbxtender.sourceforge.net
>
>