| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Environ function. | Excel Programming | |||
| Environ Function | Excel Programming | |||
| Environ() | Excel Programming | |||
| Environ()- help | Excel Programming | |||
| Have a list of Environ variables? | Excel Programming | |||
![Desert Piranha[_51_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
