access-environment-variables-in-vba.md

Access Environment Variable is VBA

Call the Environ function with the name of the environment variable.¹

Environ("USERPROFILE")

Returns:

C:\Users\<username>

The environment variable can also be accessed by index number instead of by name.

Footnotes

1. Microsoft Docs on the Environ function here ↩