Excel, LDAP and Active Directory

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!