Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't believe there is a standard set across all windows OS, but you can
see yours with Sub ListEnviron() On Error Resume Next rw = 1 For i = 1 To 100 If Environ(i) < "" Then Cells(rw, 1) = Environ(i) rw = rw + 1 End If Next Cells(rw + 1, 1) = rw End Sub I had USERDOMAIN -- Regards, Tom Ogilvy "Scott Warren" wrote in message ... I'm looking to see if any has a list, or know where I can get a list of variables that I can use the Environ() function on. Specifially I'm trying to log a users Domain when they open the file. I've been able to get the following variable so far: User = Environ("USERNAME") Machine = Environ("COMPUTERName") Thanks, -Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to match up variables to a common list and confirm | Excel Worksheet Functions | |||
Including Environ Username in Cell | Excel Worksheet Functions | |||
Transfer a list of info dependent upon variables | Excel Discussion (Misc queries) | |||
Select one variable from a list of variables by clicking one cell | Excel Discussion (Misc queries) | |||
List variables in worksheet | Excel Programming |