Use Windows Environment Variables like %APPDATA% in VBA

Sub test()

     Kill Environ("APPDATA") & "\Microsoft\Excel\XLSTART\UpdateMsg.xlam"

End Sub

Environ("USERPROFILE")          ' C:\Users\johndoe
Environ("ALLUSERSPROFILE")      ' C:\ProgramData
Environ("APPDATA")              ' C:\Users\johndoe\AppData\Roaming
Environ("LOCALAPPDATA")         ' C:\Users\johndoe\AppData\Local
Environ("SystemDrive")          ' C:
Environ("SystemRoot")           ' C:\Windows
Environ("HOMEDRIVE")            ' \Users\johndoe
Environ("windir")               ' C:\Windows
Environ("ProgramFiles")         ' C:\Program Files (x86)
Environ("CommonProgramFiles")   ' C:\Program Files (x86)\Common Files
Environ("USERNAME ")            ' johndoe
Environ("COMPUTERNAME")         ' Beta
Environ("USERDOMAIN")           ' Intranet
Environ("ClientName")           ' MyServer
Environ("SESSIONNAME")          ' Console
Environ("LOGONSERVER")          ' Which DC Auth Client Logon
Environ("OS")                   ' Windows_NT
Environ("PROCESSOR_ARCHITECTURE")' x86
Environ("PROCESSOR_ARCHITEW6432")' AMD64
Environ("PROCESSOR_IDENTIFIER")
Environ("PROCESSOR_LEVEL")
nviron("PROCESSOR_REVISION")
Environ("NUMBER_OF_PROCESSORS")