Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Excel Add-ins for Excel for Windows

Note: If you use Mac Excel 2011 or 2016 check out the Mac Tips section in the menu.

VBA Code Indentation tool Briefly! Code Indentation is a versatile tool to manage all VBA code with. It can operate with code in the VB Editor as well as with standalone vb-files, cls-files and txt-files.

Excel Function Bible, with 468 WorksheetFunction Example workbooks.

RDBMail or SendMail add-in
Briefly! RDBMail or SendMail puts emailing of Excel sheets, data, and workbooks where you want it and when you want it. It also allows significant customizing of what you send.

RDBMerge add-in
Briefly! RDBMerge is a user friendly way to Merge Data from Multiple Excel Workbooks,
csv and xml files into a Summary Workbook.

Date Picker add-in for Excel 2007-2016 with week numbers
Briefly! The Date Picker is a user friendly way to insert Dates and Week numbers into your worksheets. in 5 languages on this moment : English, German, Espa˝ol, Franšais, Danish and Russian.

Dynamic Menu for Excel 2007-2016 for Windows
Very easy to edit and add menu items for your favorite macros.

EasyFilter add-in for Excel 2000-2003
Briefly! EasyFilter is a multi-optioned tool that allows far easier filtering of data.
It allows easier manipulation of the results of the filtering.

Table Tools Add-in for Excel 2007-2016
Briefly! Table Tools is a multi-optioned tool that allows far easier filtering of data in a Table. It allows easier manipulation of the results of the filtering.

Sheet Navigator Add-in
If a workbook contains many sheets, it can be difficult to select the sheet that you want to use. The following technique creates a command, that you can use in any workbook, to create a list of sheets in that workbook. It also includes a command that sorts the sheets in alphanumeric order.
There is a version for Excel 2007 and up and one for older Excel versions.

DataRefiner add-in
Briefly! DataRefiner make it easy for a user to validate, clean and extend their data without "touching"
their existing data by inserting difficult formulas into their data tables.

VBE Bookmarks/Copy buffer add-in and Tools>References enlarger Add-in
Two very nice COM Add-ins created by Jim Rech for the Microsoft Office Visual Basic Editor.

Windows API Viewer for MS Excel Briefly! Windows API Viewer for MS Excel is a standalone powerful tool created by Dennis Wallentin for creating Windows API code, with or without conditions, to be inserted in code modules.