querying ACtive Directory Win 03

Topic

New Reply

Good evening loungers

Could someone please point in the correct direction to get to the starters box.

I wish to use vba to access user details in the AD.

The goal is to automatically populate docvariables in some Word templates.
Currently I use an access database but it is redundant if I can hit the AD.

Server 2003, Office 03

Regards
Geof

Reply | Quote

Replies

I think we’ve had a couple threads on this. Here’s an article I ran across in the past 10 minutes on using ADO: Searching the AD.

Reply | Quote

Hi Jefferson
I am off to a rasonable start with this.

The following works fine ..
objCommand.CommandText = “SELECT AdsPath,cn FROM ‘LDAP://DC = ara,DC=local’ WHERE Name = ‘geof richardson'”

I now want to pass the the contents of a text box through to that select statement
something like userform1.tbName.

I am getting all the problems associated with the quoting …

Any help would be appreciated

Regards
Geof

Reply | Quote

Hi folks

I got it

objCommand.CommandText = “SELECT AdsPath,cn FROM ‘LDAP://DC = ara,DC=local’ WHERE Name = ‘ ” & strName & “‘”

cheers
Geof

Reply | Quote