List of Environ expressions

I don't know if this is complete but it should give you something to work
with.


ALLUSERSPROFILE
APPDATA
COLLECTIONID
CommonProgramFiles
ComputerName
ComSpec
FP_NO_HOST_CHECK
HMSERVER
HOMEDRIVE
HOMEPATH
ITEMID
LANG
LOGONSERVER
NUMBER_OF_PROCESSORS
OS
OSVER
Path
PATHEXT
PROCESSOR_ARCHITECTURE
PROCESSOR_IDENTIFIER
PROCESSOR_LEVEL
PROCESSOR_REVISION
ProgramFiles
PROMPT
SESSIONID
SESSIONNAME
SWUTVER
SystemDrive
TEMP
TIMEOUT
TMP
TOOLPATH
tvdumpflags
UPDATEDIR
USERDOMAIN
USERNAME
USERPROFILE
VERSION
winbootdir
windir


Steve Yandl



"Desert Piranha"
<Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com> wrote in
message news:Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com...
>
> Hi all,
>
> Have Googled, helped and Microsofted, No joy.
>
> Is there such a thing as list of the expressions used for the "Environ"
> function?
>
> IE:
> '=Environ(UserName)
> '=Environ(Path)
> etc.
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile:
> http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=515140
>

It depends on your operationg system. You can get your list with

Sub ShowEnviron()
On Error Resume Next
For i = 1 To 100
Cells(i, 1) = Environ(i)
Next

End Sub

--
Regards,
Tom Ogilvy




"Desert Piranha"
<Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com> wrote in
message news:Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com...
>
> Hi all,
>
> Have Googled, helped and Microsofted, No joy.
>
> Is there such a thing as list of the expressions used for the "Environ"
> function?
>
> IE:
> '=Environ(UserName)
> '=Environ(Path)
> etc.
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=515140
>

Tom,
Are these indices fixed across OSs ?
i.e. 1 always returns ALLUSERSPROFILE ?

NickHK

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:u%23NLH11NGHA.916@TK2MSFTNGP10.phx.gbl...
> It depends on your operationg system. You can get your list with
>
> Sub ShowEnviron()
> On Error Resume Next
> For i = 1 To 100
> Cells(i, 1) = Environ(i)
> Next
>
> End Sub
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "Desert Piranha"
> <Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com> wrote in
> message
news:Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com...
> >
> > Hi all,
> >
> > Have Googled, helped and Microsofted, No joy.
> >
> > Is there such a thing as list of the expressions used for the "Environ"
> > function?
> >
> > IE:
> > '=Environ(UserName)
> > '=Environ(Path)
> > etc.
> >
> >
> > --
> > Desert Piranha
> >
> >
> > ------------------------------------------------------------------------
> > Desert Piranha's Profile:
> http://www.excelforum.com/member.php...o&userid=28934
> > View this thread:
http://www.excelforum.com/showthread...hreadid=515140
> >
>
>

Hey NickHK
I would think not, because I am using Windows 98SE and only have about 8
environment variables and they are numbered consecutively starting with 1.
ALLUSERSPROFILE isn't one of them.


TMP=C:\WINDOWS\TEMP
TEMP=C:\WINDOWS\TEMP
PROMPT=$p$g
winbootdir=C:\WINDOWS
PATH=C:\Program Files\Microsoft Office\Office;C:\WINDOWS;C:\WINDOWS\COMMAND
COMSPEC=C:\WINDOWS\COMMAND.COM
windir=C:\WINDOWS
BLASTER=A220 I5 D1 T4 P330


Recognize that you can define your own.
--
Regards,
Tom Ogilvy

"NickHK" <TungCheWah@Invalid.com> wrote in message
news:eI52mE2NGHA.3276@TK2MSFTNGP09.phx.gbl...
> Tom,
> Are these indices fixed across OSs ?
> i.e. 1 always returns ALLUSERSPROFILE ?
>
> NickHK
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:u%23NLH11NGHA.916@TK2MSFTNGP10.phx.gbl...
> > It depends on your operationg system. You can get your list with
> >
> > Sub ShowEnviron()
> > On Error Resume Next
> > For i = 1 To 100
> > Cells(i, 1) = Environ(i)
> > Next
> >
> > End Sub
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> >
> > "Desert Piranha"
> > <Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com> wrote in
> > message
> news:Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com...
> > >
> > > Hi all,
> > >
> > > Have Googled, helped and Microsofted, No joy.
> > >
> > > Is there such a thing as list of the expressions used for the
"Environ"
> > > function?
> > >
> > > IE:
> > > '=Environ(UserName)
> > > '=Environ(Path)
> > > etc.
> > >
> > >
> > > --
> > > Desert Piranha
> > >
> > >
> >
> ------------------------------------------------------------------------
> > > Desert Piranha's Profile:
> > http://www.excelforum.com/member.php...o&userid=28934
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=515140
> > >
> >
> >
>
>

Tom,
OK, I suppose that makes sense.

NickHK


"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eIjLgd2NGHA.2816@TK2MSFTNGP15.phx.gbl...
> Hey NickHK
> I would think not, because I am using Windows 98SE and only have about 8
> environment variables and they are numbered consecutively starting with 1.
> ALLUSERSPROFILE isn't one of them.
>
>
> TMP=C:\WINDOWS\TEMP
> TEMP=C:\WINDOWS\TEMP
> PROMPT=$p$g
> winbootdir=C:\WINDOWS
> PATH=C:\Program Files\Microsoft
Office\Office;C:\WINDOWS;C:\WINDOWS\COMMAND
> COMSPEC=C:\WINDOWS\COMMAND.COM
> windir=C:\WINDOWS
> BLASTER=A220 I5 D1 T4 P330
>
>
> Recognize that you can define your own.
> --
> Regards,
> Tom Ogilvy
>
> "NickHK" <TungCheWah@Invalid.com> wrote in message
> news:eI52mE2NGHA.3276@TK2MSFTNGP09.phx.gbl...
> > Tom,
> > Are these indices fixed across OSs ?
> > i.e. 1 always returns ALLUSERSPROFILE ?
> >
> > NickHK
> >
> > "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> > news:u%23NLH11NGHA.916@TK2MSFTNGP10.phx.gbl...
> > > It depends on your operationg system. You can get your list with
> > >
> > > Sub ShowEnviron()
> > > On Error Resume Next
> > > For i = 1 To 100
> > > Cells(i, 1) = Environ(i)
> > > Next
> > >
> > > End Sub
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > >
> > >
> > >
> > > "Desert Piranha"
> > > <Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com> wrote in
> > > message
> > news:Desert.Piranha.23lu7m_1140567901.5437@excelforum-nospam.com...
> > > >
> > > > Hi all,
> > > >
> > > > Have Googled, helped and Microsofted, No joy.
> > > >
> > > > Is there such a thing as list of the expressions used for the
> "Environ"
> > > > function?
> > > >
> > > > IE:
> > > > '=Environ(UserName)
> > > > '=Environ(Path)
> > > > etc.
> > > >
> > > >
> > > > --
> > > > Desert Piranha
> > > >
> > > >
> > >
> > ------------------------------------------------------------------------
> > > > Desert Piranha's Profile:
> > > http://www.excelforum.com/member.php...o&userid=28934
> > > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=515140
> > > >
> > >
> > >
> >
> >
>
>

it's the same list you get from the "Dos" Prompt
in a console window.

run CMD.exe
type SET [enter]

it's slightly different when you run COMMAND.com

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


NickHK wrote in <news:<e8ZxoI3NGHA.2604@TK2MSFTNGP09.phx.gbl>

> Tom,
> OK, I suppose that makes sense.
>
> NickHK
>
>