How do I: Query AD from a list of usernames in Excel

Dazman98 · Joined: 04 Oct 2007 Posts: 1

Hi

I have no real experience with VBA other than basic macro's, but I have
created a list of usernames in Excel and now I wish to Query AD to see if the
user's account is:
1. Active
2. Disabled
3. Does not exist.

If you are a coding guru, could you please help me out by providing the code
for this.

It would need to query a username from cell a1 and paste the result into a2,
then move to the next cell down, ie a2 and so on until the a.... is blank and
then stop at that point.

Thanks in advance
Dazman98

Archived from group: microsoft>public>vb>directx

Query Parameters How come when I enter the WHERE portion of the Querytable formula I get run time error '1004'? When I run the macro to retrieve info from an outside database it will pull in all of the information from the files I selected but I only want it to pull in c

Dynamically Manipulating a query i have Ms Access Database . how can i display the Monthly wise records in report? is it possible 4 using data environment? plz .... help me.........

2003 Excel Spreadsheet with a VBN file wont run with Excel 2 i have a spreadsheet the i've used for many years which auto login to 8 different sites automatically buy putting my username and pass word into a browser window so that i dont have to manually enter the username and password and than download the informa

Using Excel to Create Outlook Reminder I have a spreadsheet that lists out my employees and figures out a date to do an evaluation on them. I would like to write a Macro or VB to a list of dates to Outlook to create reminders on those dates with the employee's name. Is this possible?

Office 2007 Professional Excel is not for commercial use? I want to sell spreadsheets I create in Excel 2007. How can I do that? What additional software package must I purchase? Visual Studio or what? -- TomThumb