Works also in Office 2007

[BatMat]

This macro wroks very well on Excel 2007.

As explained in the help topic, install like this:

• Download file LDIF_to_EXCEL.bas.txt
• Rename to LDIF_to_EXCEL.bas
• Open a new Excel sheet
• Activate developpers tools:
• Click the Microsoft Office Button.
• Click Excel Options, The options window will open.
• Click Popular.
• Select the Show Developer tab in the Ribbon check box.
• Close the options window
• Click on the Developper tab in the ribbon
• Click on Visual Basic
• In the visual basic window
• Click on the menu File > Import a file ...
• Import the LDIF_to_EXCEL.bas fil
• Then click on menu Tools > References
• Tick the "Microsoft Scripting Runtime" line and validate
• In the menu select File > Close and return to Microsoft Excel
• In the Microsoft Excel workbook:
• Rename "Sheet1" to "Origen"
• Rename "Sheet2" to "Destino"
• Paste the content of your LDIF file in the first cell of the sheet named "Origen"
• Click on the Developper tab in the ribbon
• Click on "Macros
• Select the "ConvertLDIFaCSV" macro and click on "Execute"
• A popup will then ask for the starting row to convert, keep the default value (1) and validate

You will then find the result of the conversion in the "Destino" sheet.

Thank you Matias for this macro ... was working smoothly for me.

[Matias]

Thanks!