Environ()
Jan,
There is no set list as it will depend upon what environment variables have
been set on each particular machine.
Here is some code to print it all out
Dim iLoop As Long
iLoop = 1
Do
Debug.Print "#" & Format(iLoop, "00") & " " & Environ(iLoop)
iLoop = iLoop + 1
Loop Until Environ(iLoop) = ""
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Jan Kronsell" wrote in message
...
I have to add, that I have created the list myself, i just wondered if it
could be found anyywhere
Jan
"Jan Kronsell" skrev i en
meddelelse ...
Is there anywhere I can find a list of the Environment numbers I can use
with the Environ statement. like Environ(13) gives me the number of
Processors.
I have seach the VBA help wih no luck so far.
Jan
|