Soft82.com » Windows » Business » Applications » Excel LDAP Search 0.56

View screenshots

Excel LDAP Search Description

Excel LDAP Search (ELS) is an Excel add-in that allows LDAP searches to be made from within Microsoft Excel, and the resulting data to be directly imported from the directory server to the Excel document

ELS can be used to add LDAP data to existing data in an Excel document on a row-by-row basis (see Figure 1), or populate a blank sheet based on a custom query.

Limitations: ELS was designed for a fairly basic LDAP environment. Some features that are (currently) not supported are SSL, certificate authentication, and referral following.

I put together a couple of flash demo movies that show typical ELS usage for a running a query to fill in a blank Excel sheet and for adding new row data to existing Excel entries:

Requirements

I've tested querying OpenLDAP and Active Directory with the following:

* Windows XP
o Excel 2003
o Excel 2007
* Windows 2000
o Excel 2000
* Windows Vista
o untested

It uses the Mozilla LDAP SDK so it should work with any LDAP-v3 compliant directory server, and Excel 2000 (97?) to 2007. If ELS doesn't work with your directory server, please click here to submit a bug report online. It takes all of 30 seconds, and you can help out the next person who'd encounter the same problem as you.
Installation Instructions
Make sure all instances of Excel are closed.

Run the excelldapsearchinstall_x_y.exe file. This will copy the necessary files, and register everything with the system. It also opens up the config file where you can specify your connection parameters.

If you have multiple versions of Excel installed, only the latest will have the Tools menu item registered. To manually enable it in an older version, use that version to open the "ldapquery_addin.xla" document in the directory where Excel LDAP Search was installed. Press ALT-F11 to enter the macro editor and select the "ldapquery_addin.xla" project from the project explorer (if the project explorer isn't displayed, look under the "View" menu). Expand the "Modules" item and doubleclick "ldapQueryFormMacro". Look for the "Sub AddToolsMenuItem()" line, click anywhere on it with the mouse, then from the menu bar select "Run->Run Sub/User Form" or click the toolbar button with the play icon.
Known Issues
On some systems, the error message "Compile error: Can't find project or library" will be displayed. This indicates Excel is referencing a module that doesn't exist. The solution is to start the macro editor by pressing ALT-F11, then open the "Tools" menu and select "References...". If the "References..." item is greyed out, reset the project first by click the stop icon on the toolbar, or under the "Run" menu there's a "reset" item. Look for any checked items in the list that start with "MISSING:" and uncheck them. Click the "OK" button and close the macro editor. This process is also described in Microsoft KB208218.
Uninstall Instructions
Make sure all instances of Excel are closed

Remove via Control Panel->Add/Remove Programs.

If you manually added the Tools "Run LDAP Search" menu item to more than one version of Excel, you can remove it by clicking "Tools->Customize...", then opening the Tools menu again and dragging the menu item off.
Usage

After install, fire up Excel and take a peek under the "Tools" menu. There should be a "Run LDAP Search" menu item now. Click that to bring up the search GUI.

Excel 2007 users - since there is no "Tools" menu in 2007, this ends up showing up in the "Add Ins" ribbon bar thingy, but seems to work just fine.

* Adding LDAP Data to Existing Excel Data

The default option is to "Add LDAP data to existing rows" which requires a column of data where each row has an item that uniquely identfies a user (ex., a column of user IDs or e-mail addresses). If you want to get more information (ex., a mailing address or the user's full name) for each row from your directory server, set the column as the "data range" in step 1)

Excel LDAP Search Download Button For Your Site

If you want to place a Download Button for Excel LDAP Search on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Excel LDAP Search User Reviews

New Applications Software

Analyse-it! Standard Edition May 25, 2012 Transform Microsoft Excel into a comprehensive, easy-to-use statistical analysis package				MTools Ultimate May 24, 2012 The Excel Addin for Controlling and Reporting
Paperless May 22, 2012 Sustainable. Responsible. Powerful. A paper free life - all from your PC				Send Messages Personally May 22, 2012 Sends messages to the multiple recipients
gExploreFTP May 22, 2012 gExploreFTP provides access to Google Docs through any FTP client				ZUD (CMMS) May 21, 2012 Computerized Maintenance Management System (CMMS) database, single user version
Flip PDF May 21, 2012 Create online flip Books, digital edition, magazine from PDF				Alpaca Manager May 21, 2012 A software package to help you manage your Alpaca herd
Hermetic Word Frequency Counter Advanced May 18, 2012 Counts word frequencies in a file or on the clipboard				Nitro PDF Professional May 18, 2012 Create, edit and convert PDF files
Active Phone Server May 17, 2012 Speaking answering machine, Caller ID, Email Checker, Autodialer and more!				Portfolio Analyst May 17, 2012 Offers a powerful and flexible portfolio analytics
Novel Score May 17, 2012 Calculates the Type Token Ratio (Expressive Vocabulary) in any text				Zotero May 17, 2012 Grab your research with a single click
PosterPrint May 17, 2012 Print multipage posters and banners				KRO4BILL May 16, 2012 Invoice creator for many companies
Bluebeam Revu Standard Edition May 16, 2012 An intuitive PDF solution, designed for users who want to improve the way they work				Personal Cards May 15, 2012 With Personal eCards, it is easy to show those you care about that they are always in your thougts
TransTools May 15, 2012 A free collection of tools specially designed to help translators				SEVENPAR (English) May 15, 2012 Spatial Helmert transformation with seven transformation parameters

Last 7 Days Most Downloaded Applications Products

Microsoft OneNote 238 downloads Microsoft Office OneNote 2003 gives you an easier way to take, organize, and find your notes and...				Easy Flyer Creator 160 downloads Design Flyers, Brochures, Leaflets just in 5 minutes, Free Templates available
Microsoft Office Professional 135 downloads Power your business with Microsoft Office Professional 2010				Adobe Acrobat Professional 124 downloads Protect documents and accelerate information exchange with PDF
PDFCreator 104 downloads PDFCreator is a free tool to create PDF files from nearly any Windows application				Mobile Phone Tools 84 downloads Official Mobile Phone Tools Home page
Splitcam 72 downloads SplitCam is a virtual video clone and split video capture driver				WordPerfect Office X3 69 downloads Corel WordPerfect Office X3 - Standard Edition is your one-stop office suite. Ideal for large...
MicroAdobe PDF Reader 69 downloads MicroAdobe PDF Reader is a professional reader for PDF documents				Microsoft Office 2007 Help Tab 50 downloads An add-in for Word, Excel and PowerPoint 2007 that adds an additional "Help" tab

All Time Most Downloaded Applications Products

Microsoft OneNote 125,705 downloads Microsoft Office OneNote 2003 gives you an easier way to take, organize, and find your notes and...				Easy Flyer Creator 85,839 downloads Design Flyers, Brochures, Leaflets just in 5 minutes, Free Templates available
Microsoft Office Professional 29,226 downloads Power your business with Microsoft Office Professional 2010				Adobe Acrobat Professional 13,335 downloads Protect documents and accelerate information exchange with PDF
PDFCreator 95,455 downloads PDFCreator is a free tool to create PDF files from nearly any Windows application				Mobile Phone Tools 57,267 downloads Official Mobile Phone Tools Home page
Splitcam 31,114 downloads SplitCam is a virtual video clone and split video capture driver				WordPerfect Office X3 62,533 downloads Corel WordPerfect Office X3 - Standard Edition is your one-stop office suite. Ideal for large...
MicroAdobe PDF Reader 11,770 downloads MicroAdobe PDF Reader is a professional reader for PDF documents				Microsoft Office 2007 Help Tab 12,777 downloads An add-in for Word, Excel and PowerPoint 2007 that adds an additional "Help" tab