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

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