Unable to call Windows NT login

[ianquest]

Hi.

I am trying to get the Windows NT login of the users using:

Function UserNameWindows() As String
UserNameWindows = Environ("USERNAME")
End Function

...On my PC I am able to see the formula showing my login. However, when I share the file and ask another user to open the file using ofcourse their own NT login, it's not getting their NT login at all.

Does anyone have any idea how to go about fixing this?

 

[Jaafar Tribak]

Hi.

I am trying to get the Windows NT login of the users using:

Function UserNameWindows() As String
UserNameWindows = Environ("USERNAME")
End Function

...On my PC I am able to see the formula showing my login. However, when I share the file and ask another user to open the file using ofcourse their own NT login, it's not getting their NT login at all.

Does anyone have any idea how to go about fixing this?

Are Macros enabled on the other user's PC ?