Thread: Environ()
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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