Company Profile

JKP Application Development Services was founded in November 2003 by me, Jan Karel Pieterse (owner).

JKP Application Development Services develops custom-made applications, using Microsoft Office Excel® and VBA and Access and VBA to its full extent. Other Office applications are integrated into the solutions where needed.

About Jan Karel

I have been supporting Microsoft Excel users from over the world for many years, helping them with their day-to-day tasks using Microsoft Excel.

These efforts have been rewarded by Microsoft by granting me the MVP Award several times (2002 to 2008). Worldwide, there are only about 100 Excel MVP's, so with JKP Application Development Services you are sure to get top level expertise. You may find a list of recent projects on my Services page.

As a process engineer with about 20 years of corporate experience, I have experience in business processes as well as knowledge of the systems used for those processes. Here is an online interview with me.

Publications

Books

Revision author of Excel 2007 VBA Programming for Dummies. Author: John Walkenbach, publisher: Wiley. ISBN: 978-0-470-04674-6.

Magazines

Managing Editor and Author for Weka publishers, title "Financieel excelleren met Excel".

Dutch Article: “Excel 12 is in aantocht!”, Microsoft Office magazine (number 29, Spring 2006)

Dutch Article: “XML breekt door”, Microsoft Office magazine (number 27, October 2005)
You can read this article (in Dutch) here too.

Dutch article: "Excel-macro's geschikt maken voor anderen.", Microsoft Office magazine (number 25, April 2005 and number 26, July 2005). See this page for an English version of this article.

Dutch article: "Bereiknamen in Excel", Microsoft Office magazine issue number 21, 2004.

Websites

English Article: "Fixing Links To UDFs in Add-ins ", Microsoft Office Online, December 2008

English Article: "Working with Tables in Excel 2007 (VBA)", Microsoft Office Online, September 2008

Dutch article: "Werken met tabellen in Excel 2007", Microsoft voor ondernemers website, September 2007

Microsoft Knowledge base

Macro in Excel Stops After A Workbook.Open Command, February 26, 2005

Property let procedure not defined error when accessing PivotTable SourceData Property, July 18, 2004

Method to Delete Corrupt Defined Names in Excel, June 2, 2004

General

If you have a remark or a question, or would like a quotation, please use the form on my contact page or send me an e-mail.

I invite you to browse through this site. Come back often, as I add information to it regularly.

Memberships and affiliates

I am one of the founders of the "Professional Office Developers Association" and hence also a member of this organisation.