Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Welcome to the website of

JKP Application Development Services.

JKP-ADS focuses on developing applications with/for Microsoft Office.

My core business is developing solutions using Microsoft Excel/VBA and Access/VBA. Integration with other (Office) programs is possible.

How can I help you? Check out my Services page!

Read on on my English pages, you will find lots of Excel articles there!

Try my free utilities!

Click here for remote assistanceClick for remote assistance

Welkom op de website van

JKP Application Development Services.

JKP-ADS richt zich op de ontwikkeling van applicaties met/voor Microsoft Office.

De nadruk ligt op het ontwikkelen van toepassingen in Microsoft Excel/VBA en Microsoft Access/VBA. Ook integratie met andere (Office) programma's is mogelijk.

Hoe kan ik u helpen? Kijk op de Diensten pagina. 

Lees verder op mijn Nederlandse pagina's, daar vind u heel veel Excel artikelen!

Probeer mijn gratis hulpprogramma's!

Klik hier voor hulp op afstandKlik voor hulp of afstand

 

What's new on this site:

(English and/or Dutch content)

Nieuw op deze site

(Engelse en/of Nederlandse artikelen)

New article: Working with Circular references in Excel
If you've ever experienced the "Circular reference warning" popping up when you opened an Excel file read this new article. Excel detects a circular reference when a chain of calculations visits the same cell more than once. Many users get (very) confused by this message and have no idea what it is about. I'll try to demystify that message here!
Wed, 02 May 2012 15:30:00 GMT

New article: Fitting curves to your data using least squares
If you're an engineer (like I used to be in a previous life), you have probably done your bit of experimenting. Usually, you then need a way to fit your measurement results with a curve. If you're a proper engineer, you also have some idea what type of equation should theoretically fit your data. Excel provides us with a couple ...
Thu, 12 Apr 2012 15:25:00 GMT

Update: RefTreeAnalyser (build 1.0.30)
RefTreeAnalyser has been updated. I have fixed a bug in the reporting option of the tool. Do you have a license? Then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can ...
Thu, 29 Mar 2012 13:05:00 GMT

Update: RefTreeAnalyser (build 1.0.29)
RefTreeAnalyser has been updated. I have fixed a tiny bug which caused the tool to generate a runtime error when you close Excel without any open workbooks. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large ...
Tue, 14 Feb 2012 15:25:00 GMT

Update to Flexfind: Bugfix for Excel 2010
My free Flexfind tool for Excel has been updated to build 574. Excel 2010 caused problems with searching for the category Axis title.
Fri, 10 Feb 2012 08:35:00 GMT

Update: RefTreeAnalyser (build 1.0.28)
RefTreeAnalyser has been updated. I have fixed a bug regarding hidden worksheets, which could cause the tool to generate runtime errors. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? ...
Thu, 26 Jan 2012 06:55:00 GMT

Nieuw artikel: Web paginas maken met Excel Web App mashups
Met het op de markt komen van Excel 2010, heeft Microsoft ook de mogelijkheid geintroduceerd om Excel documenten on-line te bewerken, gebruik makend van de "Excel Web App". Indien je een Live account hebt, kan je een Excel 2010 bestand plaatsen op je skydrive. Iedereen die toegang heeft tot die Skydrive map, kan vervolgens dat Excel ...
Thu, 05 Jan 2012 10:25:00 GMT

New article: Creating webpages with Excel Web App mashups
With Excel 2010, Microsoft introduced the possibility to edit Excel documents on-line, using the "Excel Web App". If you have a live account, you can place an Excel 2010 file on your skydrive. Anyone who has access to that skydrive folder can then open that Excel file on-line and edit it in the browser. Moreover, you can also embed ...
Thu, 15 Dec 2011 10:25:00 GMT