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

D

Dazman98

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
 
S

Shauna Kelly

Hi

To do this task you'll need to know something about Excel and something
about querying AD. However, you've posted to a Word VBA newsgroup. I suggest
you re-post to microsoft.public.excel.programming.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Finding the height of a row in a word table from Excel 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How to add, delete usernames in exchange sign on dropdown list? 0
Displaying a range based on a cell's contents 3
how do I search thru the values in my column and replace with nessesary values 1
Printing SQL query results in a list of columns, instead of one long column 1

Top