環境変数の番号・名前・値 (Environ関数)
番号 名前と値  (=の左辺が名前、右辺が値の例)
1 ALLUSERSPROFILE=C:\Documents and Settings\All Users
2 APPDATA=C:\Documents and Settings\Administrator\Application Data
3 CommonProgramFiles=C:\Program Files\Common Files
4 COMPUTERNAME=JISAKU2004A
5 ComSpec=C:\WINDOWS\system32\cmd.exe
6 FP_NO_HOST_CHECK=NO
7 HOMEDRIVE=C:
8 HOMEPATH=\Documents and Settings\Administrator
9 LOGONSERVER=\\JISAKU2004A
10 NUMBER_OF_PROCESSORS=1
11 OS=Windows_NT
12 Path=C:\Program Files\Microsoft Office\OFFICE11\;C:\WINDOWS _
\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
13 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
14 PROCESSOR_ARCHITECTURE=x86
15 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel
16 PROCESSOR_LEVEL=15
17 PROCESSOR_REVISION=0209
18 ProgramFiles=C:\Program Files
19 SESSIONNAME=Console
20 SystemDrive=C:
21 SystemRoot=C:\WINDOWS
22 TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
23 TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
24 USERDOMAIN=JISAKU2004A
25 USERNAME=Administrator
26 USERPROFILE=C:\Documents and Settings\Administrator
27 WecVersionForRosebud.5B4=2
28 windir=C:\WINDOWS
(注) Excel2002、2000では 1:COMSPEC、2:PROMPT、3:TEMP、4:TMP、5:PATH、6:winbootdir、7:windir のみ





VBAの本 こちら


マクロ本 こちら


Excel本 こちら