Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation of input against the active directory
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation of input against the active directory
Sorry, I should post it in the 'programming' newsgroup.
"Sing Chung" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Active Directory | Excel Discussion (Misc queries) | |||
Data Connection - Active Directory | Excel Discussion (Misc queries) | |||
Login and logoff to active directory by VBA | Excel Discussion (Misc queries) | |||
Excel active directory | Setting up and Configuration of Excel | |||
can I query active directory with excel? | Excel Discussion (Misc queries) |