Welcome to the website of JKP Application Development Services
What I do
Services
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.
Products
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.
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
New tool: Keeps the Queries and Connections task pane in check
This little add-in prevents an irritating habit of Excel: It reduces the width of the Queries and Connections pane very often.
Fri, 26 May 2023 12:35:00 GMT
I've added an international issues chapter to my article on StylesIf you use Styles in VBA, watch out for international issues!
Tue, 16 May 2023 16:55:00 GMT
Updated: Flexfind allows search and replace in VBA codeGood news: As of now, Flexfind allows you to Search and replace in VBA too!
Mon, 13 Mar 2023 10:55:00 GMT
New: Flexfind JavaScript editionGood news! Today my brand new Flexfind (JS edition) has been approved for the Microsoft Office Add-ins store!
Thu, 19 Jan 2023 16:45:00 GMT
Update: RefTreeAnalyserRefTreeAnalyser has just been updated to version 3.1, build 190. Fixed a bug that caused run-time errors when using the Check Formulas option. Made the dialogs compatible with screen reader software for the visually impaired. First build that is Mac compatible!
Thu, 12 Jan 2023 15:55:00 GMT
Updated: An MSForms (all VBA) treeview.Our All VBA treeview control has been updated to version 26.5. It has been improved for accessibility and is now compatible with the Windows Narrator screen reader (for the visually impaired).
Tue, 10 Jan 2023 15:45:00 GMT
Updated two tools: GithubVBAExporter and FollowCellPointerI've Updated two tools today: GithubVBAExporter and FollowCellPointer. Find them on the download page.
Wed, 14 Dec 2022 14:30:00 GMT
Update: RefTreeAnalyserRefTreeAnalyser has just been updated to version 3.1, build 189. If your formula returns a range reference (like the XLOOKUP function does), RefTreeAnalyser will display to which cell(s) the formula points.
Wed, 02 Nov 2022 12:45:00 GMT
Show All news