System Environment Variables using VBA
These are some of the variables that are using by operating system.
The well known example is the “PATH” variable that has all the path for major software executable files and reference files.
This means that they Operating system will first search for a typed command or files in these paths.
If suppose this variable is not defined, then we have to type the complete path of each exe file in every program and command. Similar to this PATH, the other environment variables serve different purpose.
Now, we got some basic idea about environment variable.
Lets see how to read it using Excel vba code.
Excel VBA Code to Read System Environment Variables
For this purpose we can use the command VBA.Environ or VBA.Environ$.
Both serve the same purpose. We can either pass the index number of the Environment variable or its actual name.
Sub OT_Get_Environment_Variables() Dim strEnvironment As String, i As Double 'Get Environment Variable String & Path For i = 1 To 255 strEnvironment = Environ(i) ThisWorkbook.Sheets(1).Cells(i, 1) = strEnvironment Next 'Get Environment Value using String MsgBox Environ("PATH") End Sub
All these variables can be seen directly using the command prompt itself. in Windwos + R (Run command) type cmd. This in open the command prompt.
Now type “set” & press enter.
This will list all the system variables defined in your OS.
SET System Environment Variables using Excel VBA
when we are coding, we might want to set existing or create new environment variable for the program to work properly.
As far as I researched, no method does this perfectly. May be Microsoft has kept this as secure so that no program changes these settings accidentally.
If you are still looking for a good answer, please read these page. It has some good solid code.
This code snippet will set the new value to the mentioned Environment variable.