Shell Command

[Jasper Recto]

I have a shell command that looks like this:

Word = Shell("""C:\WINNT\Explorer.EXE"" """ & MyPath & """", 1)

This lauches a word document using explorer.

The problem is that it only works in Windows 2000 because the explorer.exe
is located in the WINNT directory.

If I want it to work for Windows XP, I have to create a new command that
points to the WINDOWS directory.

Is there a way to make this work in both windows 2000 and windows XP
environment with just using one command line?

Thanks,
Jasper

 

[Keven Denen]

I have a shell command that looks like this:

Word = Shell("""C:\WINNT\Explorer.EXE"" """ & MyPath & """", 1)

This lauches a word document using explorer.

The problem is that it only works in Windows 2000 because the explorer.exe
is located in the WINNT directory.

If I want it to work for Windows XP, I have to create a new command that
points to the WINDOWS directory.

Is there a way to make this work in both windows 2000 and windows XP
environment with just using one command line?

Thanks,
Jasper

Use %WINDIR% wherever your would normally put c:\winnt or c:\windows.
It refers to the location windows is installed to.

Keven Denen

 

[Douglas J. Steele]

In VBA, you'd use the Environ function:

Word = Shell("""" & Environ("WinDir") & "\Explorer.EXE"" """ & MyPath &
"""", 1)

Usually, though, %WinDir% is in the path, so

Word = Shell("Explorer.EXE """ & MyPath & """", 1)

should usually be sufficient.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a shell command that looks like this:

Word = Shell("""C:\WINNT\Explorer.EXE"" """ & MyPath & """", 1)

This lauches a word document using explorer.

The problem is that it only works in Windows 2000 because the explorer.exe
is located in the WINNT directory.

If I want it to work for Windows XP, I have to create a new command that
points to the WINDOWS directory.

Is there a way to make this work in both windows 2000 and windows XP
environment with just using one command line?

Thanks,
Jasper

Use %WINDIR% wherever your would normally put c:\winnt or c:\windows.
It refers to the location windows is installed to.

Keven Denen