Query Active Directory with Excel

dhx10000

Board Regular
Joined
Jul 11, 2005
Messages
144
Hi,

I'm wondering if someone has ever successfully queried Active Directory using Excel? I have tried to do it but do not get any data returned.

Has anyone ever done this or does any one know of a tutorial about it? I have set up a form that will allow a user to type in the name of an employee and I'd like it to query the LDAP, then display their email, and some other info in excel. I want to make sure nothing has to be done on the Active Directory side to allow me to do this before I begin to troubleshoot my code.

SR
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,118,531
Messages
5,572,723
Members
412,482
Latest member
arooshrana2
Top