Hi guys! I am a student and employee at my university and I am also fairly new to VBA. This is my first post on this forum and I would like to thank everyone in advance for the help.
I currently work for my IT department and we are launching a new phone system. I am working on an script that will allow me to search the campus LDAP by inputting a user's extension. Once the extension is inserted, the "Search LDAP" command button would then fill out "Description", "User ID", "Location", and the full phone number ("Phone") text boxes on the Userform. This would allow a visual inspection for accuracy and allow for modifications to the fields before using the "Send to Excel" button.
I will keep my request short and to the point rather than explaining the entire script in detail...
The script is still lacking the "Search LDAP" functionality. Once I obtain the variables that I need, I know what to do with them from there. I have very minimal experience using LDAP. Furthermore, my limited LDAP experience is pertained to shell commands--not VBA. I have searched the Internet for about a week now trying to obtain as much information as possible on how to do this final feature to my program. I am unable to get anything to work. Unfortunately, nobody within my department is familiar with VBA. I have seen multiple examples of similar type scripts and I am assuming that the below code is along the lines of what I will be starting with. Once the connection is established and the object is created, I assume it is fairly simple to manage the data by placing those variables wherever needed. Again, I truly appreciate your help and patience.
I currently work for my IT department and we are launching a new phone system. I am working on an script that will allow me to search the campus LDAP by inputting a user's extension. Once the extension is inserted, the "Search LDAP" command button would then fill out "Description", "User ID", "Location", and the full phone number ("Phone") text boxes on the Userform. This would allow a visual inspection for accuracy and allow for modifications to the fields before using the "Send to Excel" button.
I will keep my request short and to the point rather than explaining the entire script in detail...
The script is still lacking the "Search LDAP" functionality. Once I obtain the variables that I need, I know what to do with them from there. I have very minimal experience using LDAP. Furthermore, my limited LDAP experience is pertained to shell commands--not VBA. I have searched the Internet for about a week now trying to obtain as much information as possible on how to do this final feature to my program. I am unable to get anything to work. Unfortunately, nobody within my department is familiar with VBA. I have seen multiple examples of similar type scripts and I am assuming that the below code is along the lines of what I will be starting with. Once the connection is established and the object is created, I assume it is fairly simple to manage the data by placing those variables wherever needed. Again, I truly appreciate your help and patience.
Code:
Set oUser = GetObject("LDAP://ldap.MYCAMPUS.edu/cn=fullname,ou=user,dc=MYCAMPUS,dc=edu")
