Computer Name

hickeyt · #1 04-26-2019, 08:15 AM

Is there a VBA function to return the computer name?

hickeyt · #2 04-26-2019, 10:19 AM

Application.Username will return the name of the PC

NoSparks · #3 04-26-2019, 01:22 PM

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.

Code:

? Application.Username

? Environ$("username")

? Environ$("computername")

Alansidman · #4 04-26-2019, 01:37 PM

An alternative means to get the same results

Code:

Option Explicit

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Font and Format changes from computer to computer / device	FHANNAN87	Outlook	1	04-19-2017 03:28 PM
New computer	RetamaRobert	Office	3	03-25-2011 02:14 PM
New Computer	Rayddd	Outlook	1	01-13-2011 07:32 AM
Should I buy new software for a new computer?	Balliol	Office	1	12-27-2010 03:09 PM
Computer Stolen-Install Office 2007 On New Computer	corndale	Office	0	08-23-2010 09:52 AM