|
List of Environ expressions
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 |
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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 |
List of Environ expressions
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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 |
List of Environ expressions
Tom,
Are these indices fixed across OSs ? i.e. 1 always returns ALLUSERSPROFILE ? NickHK "Tom Ogilvy" wrote in message ... 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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 |
List of Environ expressions
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" wrote in message ... Tom, Are these indices fixed across OSs ? i.e. 1 always returns ALLUSERSPROFILE ? NickHK "Tom Ogilvy" wrote in message ... 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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 |
List of Environ expressions
Tom,
OK, I suppose that makes sense. NickHK "Tom Ogilvy" wrote in message ... 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" wrote in message ... Tom, Are these indices fixed across OSs ? i.e. 1 always returns ALLUSERSPROFILE ? NickHK "Tom Ogilvy" wrote in message ... 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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 |
List of Environ expressions
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 Tom, OK, I suppose that makes sense. NickHK |
List of Environ expressions
Hi all, Thank to everyone who contributed to this thread. Tom, Kool little macro. Thank you all Dave Tom Ogilvy Wrote: 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@excelforu m-nospam.com wrote in message news:Desert.Piranha.23lu7m_1140567901.5437@excelfo rum-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 -- 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 |
| All times are GMT +1. The time now is 09:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com