Tjyylli

Getting a UK passport renewed when you have dual nationality and a different name in your second country?

How can animals be objects of ethics without being subjects as well?

Cat is tipping over bed-side lamps during the night

Is there any differences between “gucken” and “schauen”?

Can you earn endless XP using a Flameskull and its self-revival feature?

Does the "particle exchange" operator have any validity?

Jumping Numbers

"On one hand" vs "on the one hand."

Is there a better way to make this?

Dilemma of explaining to interviewer that he is the reason for declining second interview

Why did Bush enact a completely different foreign policy to that which he espoused during the 2000 Presidential election campaign?

Do authors have to be politically correct in article-writing?

High pressure canisters of air as gun-less projectiles

Strange Sign on Lab Door

Does 'rm -fr` remove the boot loader?

Why is working on the same position for more than 15 years not a red flag?

Are there any outlying considerations if I treat donning a shield as an object interaction during the first round of combat?

Why do members of Congress in committee hearings ask witnesses the same question multiple times?

Overfitting and Underfitting

How to deal with an incendiary email that was recalled

How can I deal with a significant flaw I found in my previous supervisor’s paper?

Why can a 352GB NumPy ndarray be used on an 8GB memory macOS computer?

Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?

Could flying insects re-enter the Earth's atmosphere from space without burning up?

Excel Data Connection to Active Directory

Active Directory - Unlock TimerEvent ID 91 — AD CS Active Directory Domain Services ConnectionMissing users in Centrify active directoryIs there a way to export Active Directory data into a data base or spreadsheet?How to extract Active Directory configuration?VBA + Polymorphism: Override worksheet functions from 3rd partyStop search Active Directory when not availablePull Information From Active DirectoryActive Directory monitor attribute accessesHow do dynamically hide cells/sheets without macros

1

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!

microsoft-excel microsoft-excel-2007 active-directory

share|improve this question

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

bumped to the homepage by Community♦ 20 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

1

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!

microsoft-excel microsoft-excel-2007 active-directory

share|improve this question

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

bumped to the homepage by Community♦ 20 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

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!

microsoft-excel microsoft-excel-2007 active-directory

share|improve this question

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

share|improve this question

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

share|improve this question

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

asked Sep 26 '11 at 23:13

harvest316harvest316

30128

1 Answer
1

active

oldest

votes

0

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

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f340187%2fexcel-data-connection-to-active-directory%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

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

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

add a comment | 

0

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

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

add a comment | 

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

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

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

share|improve this answer

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445

answered Sep 27 '11 at 2:27

uSlackruSlackr

8,4012445