Excel, LDAP and Active Directory
Post date: Aug 17, 2015 12:23:24 PM
Displaying Active Directory in Excel can help office workers in several ways. Managing Active Directory in Excel can save Network Administrators time.
What is Active Directory?
Active Directory (AD) is a database storing, among other things, user accounts for a Microsoft Network, also known as a Domain. Excel can work with AD using LDAP (Lightweight Directory Access Protocol) which is a protocol for communicating with AD.
How is Active Directory important to me?
Office workers can use this app to download AD data and create:
Phone directories
Department listings
Routing slips (for birthday, anniversary, sympathy cards)
And more.
Network Admins can use this app to update user phone numbers or assigned department/company.
VBA Developers can use this app as a guide to working with Active Directory.
Background
We recently installed a new phone system. Extensions changed. Direct –in-dial numbers changed. Updates to AD were required; however, using Microsoft’s Active Directory app, while great for one user changes, doesn’t handle bulk updates. So I created this app to make that job easier.
At the same time, users needed an updated directory listing. This app’s display function provides the most up-to-date directory listing possible without burdening staff, killing trees, or adding to the landfill.
Getting the App
Use the links below to get a copy of LDAP.xlsm. Use it or explore it. Like all BXL apps, the code is unprotected and documented. The accompanying PDF provides download links, user documentation, and technical documentation.
Keep XL'n!
Download the PDF at: https://www.dropbox.com/s/ahf6opm2gp9pyxn/LDAP.pdf?dl=0
