Data Connection - Active Directory

Rob · 07-13-2006, 03:05 PM

Can anybody tell me how to get information from Active Directory into Excel.
I need to get a list of users and workstations in a worksheet and figured I
can do that with the Data Connection Wizard using these steps:

Data Connection Wizard
Other/Advanced
OLE DB Provider for Microsoft Directory Services

Now I need to fill in a Data Source and Location but I have no idea what to
fill-in here...

Thanks, Rob

MESCWB · 08-11-2006, 02:00 PM

Yes! I need this too, MVPs! please help us
I have an OU I wish to import into a workbook and won´t do that by VBA, but
just define a new data source

TIA

**harvest316** · 09-25-2011, 08:14 PM

I concur. Have raised it on Stack Overflow.

**teylyn** · 09-25-2011, 08:27 PM

harvest316, welcome to the forum.

I don't quite see the benefit of posting into a newsgroup thread from 2006 and the only thing you're contributing is a link to a competitor site where the question has not even been answered.

Many people post many questions in many a Q&A site every day. Somehow I don't think that these need to be collected in this forum.

If you have a question, please start a new thread. If you can provide an answer to a question, please do so in a reply to a question.

Thanks,