Username Query

redma_d · #1 (**permalink**) 02-23-04, 15:51

Is there a way to capture the pc username instead of using application.username?

(The PCs in question are installed with NT4 or XP Pro and Excel 97 - lowest version)

Many thanks in advance

Smitty · #2 (**permalink**) 02-23-04, 17:50

How about:

Code:

Sub GetMyName()
    Dim CurrentUserName As String
        CurrentUserName = Environ("Username")
    MsgBox CurrentUserName
End Sub

Hope that helps,

Smitty

redma_d · #3 (**permalink**) 02-23-04, 18:56

Smashin ... i knew there must be an easy answer to it ...

Cheers

Internet Services

Web Development

Digital Marketing

Consumer Tech