Welkom op de website van JKP Application Development Services
Wat ik doe
Diensten
Ik bied diensten aan met betrekking tot ieder aspect van Excel en VBA. De
Diensten
pagina bevat voorbeelden hiervan. U vindt er ook een lijst met recente
projecten.
Producten
Ik ontwikkel maatwerkoplossingen in Excel voor klanten en ook
Excel invoegtoepassingen voor algemeen gebruik zoals mijn spreadsheet
audit tool RefTreeAnalyser. Bekijk hier
producten die ik heb ontwikkeld.
Gratis Excel downloads
Ik ontwikkel maatwerk applicaties gebruik makend van Microsoft
Office Excel® en VBA en Access en VBA. Bekijk de
(gratis) downloads,
waarvan enkele de facto standaard voor Excel ontwikkelaars zijn
over de hele wereld.
Wie is Jan Karel?
Wilt u meer te weten komen over mij?
Op deze pagina komt u iets meer te weten over mij en vind u een lijstje met enkele presentaties die ik de laatste jaren gegeven heb.
Nieuw op deze site
Engelse en/of Nederlandse artikelen
Updated: Flexfind JavaScript edition
Today I've updated my Flexfind (JS edition). I've added an option to either search in Values or in Formulas and Contiguous ranges are now displayed as one block (A1:B2) instead of as individual cells. To get the update, load the add-in in the usual way, click in it's pane and press control+F5
Tue, 04 Jun 2024 14:40:00 GMT
Updated: FlexfindFlexfind was updated to fix a bug when the replace string contains a # character
Tue, 28 May 2024 16:00:00 GMT
Update: RefTreeAnalyserRefTreeAnalyser has just been updated to version 3.1, build 211. Fixed issue with OK button of the ToC dialog not responding to a mouse click. Build 210 added: Now shows What's new, the first time an updated version is loaded. When timing formulas takes very long, RefTreeAnalyser will temporarily show an option to stop the timing. When you click the Precedents button (or its short-cut key) and an object is selected and not a range of cells, RefTreeAnalyser will show the references used by the object.
Thu, 23 May 2024 09:15:00 GMT
Update: RefTreeAnalyserRefTreeAnalyser has just been updated to version 3.1, build 210. Now shows What's new, the first time an updated version is loaded. When timing formulas takes very long, RefTreeAnalyser will temporarily show an option to stop the timing. When you click the Precedents button (or its short-cut key) and an object is selected and not a range of cells, RefTreeAnalyser will show the references used by the object.
Wed, 22 May 2024 14:00:00 GMT
New article: Lambda function examplesI have added a new article to my website today, in which I demonstrate a couple of LAMBDA functions: SheetName and JustifyText
Fri, 17 May 2024 16:45:00 GMT
Update: Name ManagerName Manager has just been updated to build 708. If you open the Add Name box, the current selection is already entered in the refersto formula
Fri, 17 May 2024 14:10:00 GMT
Update: RefTreeAnalyserRefTreeAnalyser has just been updated to version 3.1, build 207. Fixed error on hard-coded number cells when sheet has no formulas. Improved performance of selecting nodes in the precedents tree. Fixed issue when running off-sheet references on a workbook with workbook protection.
Fri, 19 Apr 2024 10:15:00 GMT
Office Script, more examplesI have added an example to my Office script examples page: how to filter a date column in a table for dates older than today.
Thu, 21 Mar 2024 10:50:00 GMT
Toon Al het nieuws