I use this code to find the user of a computer. Its giving a error when used on 64bit excel. Thoughts?
VBA Code:
Private Sub Workbook_open()
'Sub GetComputerUserName()
Dim UserName As String
'Getting user name
UserName = Environ("username")
'Assigning value to cell C10 and C11
Range("lookupname").Value = UserName
End Sub