Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to create a data connection in Excel 2007 that pulls the result of an Active Directory query into a sheet in my workbook.

I see that I can do this with VBA: http://www.remkoweijnen.nl/blog/2007/11/01/query-active-directory-from-excel/ but I agree with Rob here that it should be easier than that, just using "OLE DB Provider for Microsoft Directory Services"

A bit of googling suggests that this is a hole in our collective knowledge that deserves to be filled!

share|improve this question

1 Answer 1

I don't believe that is going to work. Best work-around I can think of is to use Powershell's export-csv to export your AD query. Somthing like:

get-aduser -filter * | select Name, employeeid, office, postalcode|export-csv "myADexport.csv"
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.