Data Connection - Active Directory

[Guest]

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

 

[Guest]

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