Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

Excel Add-ins for Excel for Windows

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


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

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

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.

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.

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.

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.