I have searched the forum several way to resolve my issue and the only solutions were as follows:
Problem is that I get a #REF! and #NAME? instead of the user namesPHP Code:
Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function
I am using Excel 2000 (I can not upgrade, Government PC) plus we need it to support Excel 2000 - present versions.
thanks
Bookmarks