Dear all,

I thought there was an easy way to get the windows system
directory but I can't find it.

Anybody an idea?

Thanks,

JOhn

%windir%

You can put that directly into a path.


--

Regards,


Bill Lunney
www.billlunney.com

"John" wrote in message
...
Dear all,

I thought there was an easy way to get the windows system
directory but I can't find it.

Anybody an idea?

Thanks,

JOhn

Thanks Bill for your quick reply,really appreciated.
However... I am not sure how to use and can't find help on
it.

I am trying to replace the "c:\winnt\" in the following
code so help will always be found no matter where my xla
is called from:

Sub ShwHelp()
Application.Help "C:\WINNT\TPBQ.CHM"
'%windir%
End Sub

Any idea?

Thanks for your help.

John



-----Original Message-----
%windir%

You can put that directly into a path.


--

Regards,


Bill Lunney
www.billlunney.com

"John" wrote in message
...
Dear all,

I thought there was an easy way to get the windows
system
directory but I can't find it.

Anybody an idea?

Thanks,

JOhn


.

In Excel XP, I can do the following....

Sub Demo()
Dim s
s = Application.OperatingSystem ' If you want to test
s = CreateObject("Scripting.FileSystemObject").GetSpec ialFolder(0)
Debug.Print s
End Sub

Returns...
C:\WINDOWS

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"John" wrote in message
...
Thanks Bill for your quick reply,really appreciated.
However... I am not sure how to use and can't find help on
it.

I am trying to replace the "c:\winnt\" in the following
code so help will always be found no matter where my xla
is called from:

Sub ShwHelp()
Application.Help "C:\WINNT\TPBQ.CHM"
'%windir%
End Sub

Any idea?

Thanks for your help.

John



-----Original Message-----
%windir%

You can put that directly into a path.


--

Regards,


Bill Lunney
www.billlunney.com

"John" wrote in message
...
Dear all,

I thought there was an easy way to get the windows
system
directory but I can't find it.

Anybody an idea?

Thanks,

JOhn


.

In a command window you can do

Echo %windir%
and it returns
C:\Winnt
on my system. Not sure how you would use it in VBA

You can check the comspec environment variable

? environ("comspec")
C:\WINNT\system32\cmd.exe

or
? environ("windir")
C:\WINNT

I am on Win 2K and I can't guarantee that these environ variables will be
defined on every OS version.

Other methods:

http://support.microsoft.com/default...b;en-us;170728
OFF97: Macro to Get Windows and Windows System Directories

http://support.microsoft.com/default...b;en-us;213496
XL2000: Macros to Return Windows and System Directory Paths

http://support.microsoft.com/default...b;en-us;108278
XL: Macros to Return Windows and System Directory Paths

--
Regards,
Tom Ogilvy




"John" wrote in message
...
Thanks Bill for your quick reply,really appreciated.
However... I am not sure how to use and can't find help on
it.

I am trying to replace the "c:\winnt\" in the following
code so help will always be found no matter where my xla
is called from:

Sub ShwHelp()
Application.Help "C:\WINNT\TPBQ.CHM"
'%windir%
End Sub

Any idea?

Thanks for your help.

John



-----Original Message-----
%windir%

You can put that directly into a path.


--

Regards,


Bill Lunney
www.billlunney.com

"John" wrote in message
...
Dear all,

I thought there was an easy way to get the windows
system
directory but I can't find it.

Anybody an idea?

Thanks,

JOhn


.