complte username about domain and usename

[sal21]

I dont know if is possible...
Hans, please take a eyes here!
I know the username s.a. OU1234556 and domain name MYDOMAIN is possibleb to have the complete name of username similar Jhon Smith?
Please with vb6 or vba for excel

[HansV]

I'm sure it's possible, but I have no idea how to do that.

[Leif]

Perhaps Charles Maxson : Excel VBA: Function to get logged in user name (plus the Environ Function) might help?

[HansV]

Leif, the code posted there will return the Windows login name, "OU1234556" in Sal21's example.

On a domain, the full name of the user ("Jhon Smith") may be available in Active Directory (AD). I interpreted Sal's question to be how to extract the full name from AD if you know the login name.

I found some old code that says it's for Windows NT and 2000; I suppose it'll work for Windows XP too, but I have no idea whether it'll work in Windows Vista or Windows 7 on a domain. (On my home PC, it returns an empty string).

I have attached the code, for what it's worth. It should be copied into a module.

GetUsername.txt

[sal21]

Leif, the code posted there will return the Windows login name, "OU1234556" in Sal21's example.

On a domain, the full name of the user ("Jhon Smith") may be available in Active Directory (AD). I interpreted Sal's question to be how to extract the full name from AD if you know the login name.

I found some old code that says it's for Windows NT and 2000; I suppose it'll work for Windows XP too, but I have no idea whether it'll work in Windows Vista or Windows 7 on a domain. (On my home PC, it returns an empty string).

I have attached the code, for what it's worth. It should be copied into a module.

GetUsername.txt

l.

Sure Hans this is exactlly wath i need!!!!!!!!!!!!!!!!
Only you!
Sa

[StuartR]

...I have no idea whether it'll work in Windows Vista or Windows 7 on a domain...

It worked correctly for me, using a Windows Vista PC logged into my work domain via a VPN connection.

[HansV]

Thanks for the confirmation, Stuart!