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

G

Guest

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
 
R

Rory Becker

I have no real experience with VBA other than basic macro's

This is the case also with many people in this forum.

Whilst you might get lucky, I suggest you might have better luck looking
in a VBA forum. This one is primarily concerned with VB.Net
 

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

Excel, assign cells in multiple worksheets from one sheet 1
Excel Query setup 0
Obtain a list of users in database in VBA 7
VBA: How can I use a string variable as autofilter criteria? 4
Excel Excel: How do I put a formula in a drop down list 11
How do I view Usernames in active directory users and comptuers 4
Integrating certain Excel cells into a Word document... 1
Excel How do I automatically populate an excel, word & outlook templates from an excel file 0

Top