Computer Name

[hickeyt]

Is there a VBA function to return the computer name?

[hickeyt]

Application.Username will return the name of the PC

[NoSparks]

Are you sure about that?
Or is it not the computer name that you really want?

On my computer, In the vba Immediate window, these lines give three different results.
Only one is the actual computer name.

? Application.Username

? Environ$("username")

? Environ$("computername")

[Alansidman]

An alternative means to get the same results

Option Explicit

Sub CompName()
    MsgBox (Application.UserName)
    MsgBox (Environ("username"))
    MsgBox (Environ("computername"))
End Sub