【VBA】Get Computer Name

You can get
“Computer Name“！

Use “Environ function“！

Contents

VBA Code

You can get “Computer Name” by “Environ function“.

Sub sampleProc()
    'Get "Computer Name"
    MsgBox Environ("COMPUTERNAME")
End Sub

Set “COMPUTERNAME” to “Environ function“(Line 3).

You got “Computer Name“！

Also, you can get “User Name“.

For more information, see the following article:

Also, you can get “path to the Desktop“.

For more information, see the following article:

For more information about following, see the following official online manual:

●Environ function