Returns the value of an environment variable as a string. Environment variables are dependent on the type of operating system that you have.
Environ (Environment As String)
Environment: Environment variable that you want to return the value for.
Sub ExampleEnviron Dim sTemp As String sTemp=Environ ("TEMP") If sTemp = "" Then sTemp=Environ("TMP") MsgBox "'" & sTemp & "'" ,64,"Directory of temporary files:" End Sub