I offer services pertaining to any aspect of Excel and VBA. My Services page shows you examples of services I provide. You will also find a list of recent projects there.
I develop bespoke Excel tools for customers and also Excel add-ins for the general public, like my spreadsheet auditing tool RefTreeAnalyser. Check out products I have developed.
I offer both pre-scheduled trainings and custom-made courses. Content of trainings can be adapted to your needs. If preferred we also offer any course as an in-house training.
Subscribe to our news letter or check out the archive. There is no set frequency, I just post something when I have time. In any case, it is all about Excel.
I develop custom-made applications using Microsoft Office Excel® and VBA and Access and VBA to their full extent. Have a look at various (free) downloads, some of which have become the de facto standard for Excel developers around the world.
Would you like to learn more About me? On this page you can get to know me a little better and also find a short list of presentations I've given over the past years.
English and/or Dutch content
Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 137. Fixed a couple of bugs and added exceptions to deleting names with external references.
Tue, 05 Dec 2023 09:55:00 GMT
RefTreeAnalyser has just been updated to version 3.1, build 203. Added search in conditional formatting: databars, color scales and icon sets, Added Python support, Fixed bug in highlighting reference in formula, Fixed bug in Visualize, Fixed bug in insert link to ToC, Fixed bug in Formula report, now ignores text values starting with =
Thu, 09 Nov 2023 16:45:00 GMT
I have updated the TableTools add-in. Fixed a small bug in updating the queries
Tue, 24 Oct 2023 17:10:00 GMT
Good news! Today I've updated my Flexfind (JS edition). To get the update, load the add-in in the usual way, click in it's pane and press control+F5
Mon, 16 Oct 2023 16:45:00 GMT
I've fixed a small bug, if any of the VBA projects is protected the tool now gracefully exits. ExportVBAProject writes the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.
Thu, 28 Sep 2023 09:15:00 GMT
Name Manager has just been updated to build 703. Removed 240 character limitation from the Edit RefersTo box
Thu, 31 Aug 2023 16:30:00 GMT
Flexfind was updated with an improved report (the List button)
Wed, 30 Aug 2023 13:55:00 GMT
I have added an example to my Office script examples page: how to enter zeroes in all empty cells in a range.
Thu, 17 Aug 2023 11:10:00 GMT
Show All news