Validation of input against the active directory

S

Sing Chung

A spreadsheet contains a column of valid AD user names. I would like to
validate the user's input of these names against the active directory user
account 'display name' property after user key-in data into this column.
Sample data:
Time Server Login Name Login Reason
07:01 SS233 Username 123 M20080410000321
12:40 SS1728 Username 234 Remedy 434343
16:24 MM213 Username 244 Trouble 042323
How can I use a macro to detect changes in Login Name and if corresponding
Server cell is not empty, then lookup in the AD, validate if the spelling of
Login Name entered is correct?
 

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

Validation of input against the active directory 2
Reading Active Directory fields 7
Sync Active Directory with Existing Resource and User Pool 8
Validate user against Active Directory 1
Active Directory Synchronisation Partial Failure 2
Scheduled Active Directory Synchronization doesn't work 3
Problem with Active Directory 0
project cannot open the file 0

Top