Taje user name to look up department

[wdverner]

Hi All,
I have retrieved the logged on user via
strUserName = objNetwork.UserName

What I want to do now is to look up what Department this user works in as specified in the users profile within Active Directory.

I can do this by specifying a username:
Set objUser = GetObject _
("LDAP://cn=ENTER USER HERE,cn=users,dc=MyDomain,dc=DC01,dc=com")

What I want is for the LDAP to take strusername and use this in place of what I manually type e.g. MY USER NAME.

Is this possible?

Thanks guys

 

[PHV]

You wanted this ?
Set objUser = GetObject _
("LDAP://cn=" & strUserName & ",cn=users,dc=MyDomain,dc=DC01,dc=com")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdverner]

Hi PHV,
Thanks for the reply, no tried that and it doesnt want to know!