Home Newsletter

Deze pagina in het Nederlands

Welcome to the website of JKP Application Development Services

What I do


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.

Free Excel tools

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.

Who is Jan Karel?

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.

What's new on this site

English and/or Dutch content

Updated: Compare Two Tables
I've updated the tool so it also works on files stored in Sharepoint or OneDrive.
Wed, 20 Oct 2021 09:45:00 GMT

Updated: Compare Two Tables
I've fixed a bug in the tool which caused the tool not to work with numeric indices.
Mon, 18 Oct 2021 16:30:00 GMT

Office Script, Called from Power automate
In this new article, I show you how to apply an Office Script to all Excel files in a OneDrive (for business) folder. The script adds a Table of Contents sheet (which neatly lists all worksheets and all charts) to each Excel file in the folder.
Fri, 08 Oct 2021 16:30:00 GMT

Office Script, enkele voorbeelden
Sinds Juli 2020 kunnen Microsoft 365 gebruikers hun acties in Excel laten opnemen als Office Script macro's. Eerder plaatste ik al een artikel dat laat zien hoe je hiermee start. Op deze pagina toon ik wat voorbeelden van Office scripts die je niet kunt opnemen met de Script recorder, maar die wel nuttig zijn.
Thu, 26 Aug 2021 13:05:00 GMT

Office Script, some examples
Since 2020, Microsoft 365 users can record their actions in Excel on-line into Office Script macros. This article shows example scripts which you cannot record but might come in handy.
Tue, 24 Aug 2021 15:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed an issue with the links on each sheet back to the ToC.
Fri, 20 Aug 2021 13:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added Tables to the table of content option.
Tue, 17 Aug 2021 17:20:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added Form and ActiveX controls to the table of content option.
Fri, 13 Aug 2021 16:10:00 GMT

Show All news