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.

My Services page shows you what services I can provide. This page also includes a list of recent projects so you can assess my level of experience in the business.

My Products page shows some samples of products I have developed.

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 (each year starting from 2002). Worldwide, there are only about 100 Excel MVP's, so with JKP Application Development Services you are sure to get top level expertise.

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.

Speaking engagements

Getting (external) data into Excel, Excel Experts Class 2011, December 9, 2011, Utrecht

Advanced userforms, Excel Experts Class 2011, December 9, 2011, Utrecht

VBA: workimg with variables, Excel Experience Day 2011, December 8, 2011, Ede

Using Userforms in VBA-macro's, Excel Experience Day 2011, December 8, 2011, Ede

Distributing VBA Macro’s to other users, Excel Experts class 2010, December 10, 2010, Amsterdam

Introduction to Excel VBA, Excel Experience Day 2010, December 9, 2010, Ede

Presentation at the Microsoft Global MVP Summit at Redmond. Presenting to the Microsoft Office Excel product group. Content and title under NDA. February 16, 2010. Redmond WA, USA.

Practical applications with VBA. Excel Beginner to intermediate level presentation on Excel VBA with practical examples. December 10, 2009. Ede, The Netherlands.

Using Pivot Tables. "The Excel Experience Day 2008", December 11, 2008. Ede, The Netherlands.

Introduction to Excel VBA. "The Excel Experience Day 2008". December 11, 2008. Ede, The Netherlands.

Avoid mistakes, pitfalls in using Excel. "Excel Experience day 2007". December 11, 2007. Ede, The Netherlands.

Introduction to Excel VBA. "Excel Experience day 2007". December 11, 2007. Ede, The Netherlands.

Excel Masterclass. "Nationale Office dag". November 30, 2006 Ede Netherlands.

Excel and XML, an Introduction, "Excel experience day 2006". December 7, 2006. Ede, The Netherlands.

Excel 12, "Nationale Office dag". November 29, 2005. Ede, The Netherlands.

Publications

Books

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

Magazines

Dutch article: Opstartproblemen verhelpen in Excel; Microsoft Technet magazine No. 2, May 2010, Microsoft.

Author and editorial staff member for www.wekafinancieel.nl, managed by Weka publishers.

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

Importing Text Files in an Excel Sheet, Microsoft blog, June 10, 2010

Where to Find the Form Controls Microsoft blog, February 13, 2010

Preventing auto_open and Workbook_Open events from running Microsoft blog, December 15, 2009

Using parameters with web queries, Microsoft MSDN article, August 2009

Editing Data in an Excel 2007 Open XML File with VBA, Microsoft, June 2009

Using Styles to Dress Up Your Worksheets in Excel 2007, Microsoft MSDN, March 2009

Fixing Links To UDFs in Add-ins, Microsoft Office Online, December 2008

Working with Tables in Excel 2007 (VBA), Microsoft Office Online, September 2008

Werken met tabellen in Excel 2007 (Dutch), Microsoft voor ondernemers website, September 2007

Microsoft Knowledge base

How to troubleshoot startup problems in Excel, June 2009

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.