1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Function VariablesEnvironnement()
Dim varEnv As Variant, intI As Integer
Dim strMessage As String, v As Variant
' Liste des variables d'environnement
varEnv = Array("ALLUSERSPROFILE", "APPDATA", _
"COMPUTERNAME", "HOMEDRIVE", "HOMEPATH", _
"LOGONSERVER", "NUMBER_OF_PROCESSORS", "OS", _
"PATH", "PATHEXT", "PROCESSOR_ARCHITECTURE", _
"PROCESSOR_IDENTIFIER", "PROCESSOR_LEVEL", _
"PROCESSOR_REVISION", "PROMPT", _
"SYSTEMDRIVE", "SYSTEMROOT", "TEMP", "TMP", _
"USERDOMAIN", "USERNAME", "USERPROFILE")
'Déclaration des variables DAO
Dim dbBase As DAO.Database
Dim rst As DAO.Recordset
'Instancie la base courrante
Set dbBase = CurrentDb
'charge la table dans le Recordset rst
Set rst = dbBase.OpenRecordset("Var", dbOpenDynaset)
'Boucle sur le tableau
For Each v In varEnv
rst.AddNew 'Ajoute un enregistrements
rst!NomVar = v 'v dans champ NomVar
rst!ValeurVar = Environ(v) 'environ(v) dans champ ValeurVar
rst.Update
Next v
Set rst = Nothing
Set dbBase = Nothing
End Function |
Partager