Home Article Index Links Newsletter

Deze pagina in het Nederlands

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.

Training

I offer both pre-scheduled trainings and custom-made courses. Content of trainings can be adapted to your needs. If preferred we also offer any course as an in-house training.

Newsletter

Subscribe to our news letter or check out the archive. There is no set frequency, I just post something when I have time. In any case, it is all about Excel.

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

A new tool: Github VBA exporter
I've added a new tool (in beta!!) to my download section called Github VBA Exporter. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of ...
Wed, 13 Jan 2021 10:30:00 GMT

Update: Name Manager
Name Manager has just been updated to build 675. You can now filter for Lambda names and you can edit name comments
Mon, 14 Dec 2020 13:55:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added two new options: 1. Generate a Table of Contents and 2. Added a feedback button which takes you to a small survey so you can tell me what you like and what you do not like.
Fri, 04 Dec 2020 11:00:00 GMT

Video: Smart Macro Recording
I presented during the Excel Virtually Global conference in July 2020, Here's the recorded video: Smart VBA Macro Recording
Mon, 24 Aug 2020 16:15:00 GMT

Updated article: Prevent Open Event
I have updated my existing article on how to prevent Open events from running as Microsoft has changed the way Excel responds to the Shift key being held down (it now ignores it).
Thu, 13 Aug 2020 16:15:00 GMT

New article: Enabling Drag and Drop between two Listboxes on a VBA Userform
I have added a new article today which shows how to enable drag and drop between two listboxes on an Excel userform
Wed, 10 Jun 2020 10:30:00 GMT

Nieuw artikel: Gegevenstypen gebruiken in Excel
Ik heb een artikel toegevoegd over het gebruik van Gegevenstypen in Excel.
Thu, 21 May 2020 16:00:00 GMT

New article: Using Data Types in Excel
I have added a new article today about data types in Excel.
Fri, 08 May 2020 15:20:00 GMT

New article: A Generic Spreadsheet Template
I have added a new article today about what every spreadsheet models should contain. With a free download too!
Fri, 01 May 2020 17:40:00 GMT

Nieuw artikel: Een Generiek Spreadsheet Sjabloon
Ik heb een nieuw artikel toegevoegd vandaag over wat er in ieder goed Excel bestand zou moeten zitten. Met gratis download.
Fri, 01 May 2020 17:40:00 GMT

The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass for these dates: May 18, 20, 26 and 28, 2020 June 2 and 4, 2020. The masterclass will be completely on-line, using Microsoft Teams. Make sure you register now
Thu, 23 Apr 2020 09:25:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added PowerQuery M code to Object search. Fixed a bug regarding finding cell references in Objects
Wed, 15 Apr 2020 10:55:00 GMT

Updated: Compare Two Tables
I've fixed two bugs in the tool.
Fri, 10 Apr 2020 15:00:00 GMT

Update: Name Manager
Name Manager has just been updated to build 672. Range names generated by the new LET function are now correctly identified as system names
Wed, 1 Apr 2020 10:40:00 GMT

Update: Name Manager
Name Manager has just been updated to build 671. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT

Webinar recording: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10:50:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once
Wed, 15 Jan 2020 09:20:00 GMT

Updated : Table Tools
I have updated the TableTools add-in, with a couple of bug fixes.
Mon, 13 Jan 2020 13:30:00 GMT

The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now
Tue, 26 Nov 2019 12:45:00 GMT

New download: Excel Spreadsheet Model Template
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in
Tue, 12 Nov 2019 09:45:00 GMT

Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 128. Added "Copy sheet special" item to right-click menu of worksheet tabs.
Thu, 31 Oct 2019 09:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the layout of the Object references dialog
Wed, 30 Oct 2019 16:15:00 GMT

Updated article: Working with Circular references in Excel
I have updated the page on VBA driven circular reference calculations
Tue, 22 Oct 2019 11:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue where references are not found when formula contains new line character (alt+enter).
Thu, 26 Sep 2019 12:15:00 GMT

And the winner is...
Today I've posted the solutions I received for my Excel challenge of August 2019 named Combinations, Combinations.
Thu, 19 Sep 2019 14:00:00 GMT

Updated: Compare Two Tables
I've enabled the Compare2Tables tool to work on 64 bit Excel.
Tue, 03 Sep 2019 14:50:00 GMT

Updated: Pivottable Slicers, Synchronizing slicers
I have added a download file to the article on how to synchronize slicers from different caches.
Thu, 29 Aug 2019 15:05:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved the Check Formulas interface.
Tue, 06 Aug 2019 16:19:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a small bug pertaining to hard-coded strings in formulas.
Mon, 29 Jul 2019 16:45:00 GMT

Update: CorruptFiles
I have updated my little article on corrupt Excel files.
Mon, 29 Jul 2019 16:45:00 GMT

Updated article: Keeping Userforms on top of SDI windows in Excel 2013 and up
I've just fixed a bug in the class module which caused errors when you would minimize an Excel window. Thanks to Philippus, who reported this bug.
Mon, 01 Jul 2019 09:45:00 GMT

Updated: Compare Two Tables
I've added a new feature to the Compare2Tables tool. You can now select which difference tables you want the tool to produce.
Tue, 02 Apr 2019 16:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added a feature where pressing find precedents on a Pivot chart will select the underlying pivottable.
Tue, 26 Mar 2019 12:55:00 GMT

A new tool: Compare Two Tables
I've added a new tool (in beta!!) to my download section called Compare2Tables.
Mon, 25 Feb 2019 17:00:00 GMT

Update: Name Manager
Name Manager has just been updated to build 666. Name Manager will now recognize names starting with _xlfn as Excel system names.
Tue, 22 Jan 2019 13:50:00 GMT

Updated : Flexfind
Flexfind has been updated with a small number of improvements: better search in chart items and better grouping of cells with identical formulas.
Wed, 16 Jan 2019 07:50:00 GMT

Updated : Table Tools
I updated the TableTools add-in, with a couple of bug fixes.
Mon, 12 Nov 2018 15:15:00 GMT

Updated : Table Tools
I updated the TableTools add-in, which now ensures name changes of Tables are updated in PowerQuery queries!
Fri, 09 Nov 2018 08:30:00 GMT

The Excel VBA Masterclass
I'm scheduling a new run of my Excel VBA Masterclass soon.
Wed, 31 Oct 2018 13:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug regarding getting references from chart series.
Wed, 31 Oct 2018 13:45:00 GMT

The Ljubljana Excel VBA Masterclass
Come and join me in Ljubljana November 5th, 2018 for The Ljubljana Excel VBA Masterclass. Make sure you Visit the Website
Mon, 1 Oct 2018 15:55:00 GMT

Update to Flexfind
Updated: Flexfind. Flexfind was updated to build 595 in which I fixed an issue when searching across multiple workbooks.
Mon, 1 Oct 2018 15:35:00 GMT

Update: Name Manager
Name Manager has just been updated to build 664. Name Manager will no longer mark names using the new Dynamic Array references as names with errors.
Wed, 26 Sep 2018 15:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. It now works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references.
Wed, 26 Sep 2018 15:15:00 GMT

Update: Name Manager
Name Manager has just been updated to build 660. In case of a compile error, Name Manager will automatically turn off its feature to display a toolbar in the VBA editor.
Tue, 04 Sep 2018 16:00:00 GMT

Update: Name Manager
Name Manager has just been updated to build 659. Fixed a problem 64 bit Excel users might experience.
Mon, 03 Sep 2018 16:35:00 GMT

Update: HeaderFooter
My HeaderFooter tool has been made 64 bit compliant.
Fri, 24 Aug 2018 14:05:00 GMT

Update: Name Manager
Name Manager has just been updated to build 958. Fixed a problem caused by a Windows 10 bug.
Fri, 06 Jul 2018 14:05:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and reporting significantly.
Thu, 14 Jun 2018 19:05:00 GMT

Update: Privacy Beleid JKP-ADS
Ik weet het, saaaaai. Maar het moest er van komen ivm de AVG. Ons Privacy Beleid is aan onze site toegevoegd.
Mon, 28 May 2018 10:25:00 GMT

Update: Company Privacy Policy
I know, boring, but it had to be done thanks to the GDPR. Our Company Privacy Policy has been added to our website.
Mon, 28 May 2018 10:25:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Adapted site addresses to use https.
Thu, 24 May 2018 16:15:00 GMT

Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 123. Adapted site addresses to use https.
Thu, 24 May 2018 16:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed runtime error due to third-party add-ins when checking if tool is installed.
Wed, 02 May 2018 16:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Included Array formulas in circular reference checks.
Mon, 09 Apr 2018 17:00:00 GMT

Nieuw artikel: Gebruikers-vriendelijke gegevensvalidatie met weergave van hulp die niet in de weg staat
Ik heb een nieuw artikel toegevoegd vandaag over hoe je Gebruikers-vriendelijke gegevensvalidatie met weergave van hulp die niet in de weg staat maakt in Excel.
Sat, 17 Mar 2018 16:00:00 GMT

New article: Creating a user-friendly Data Validation in Excel Displaying help out of the way
I have added a new article today about Creating a user-friendly Data Validation in Excel Displaying help out of the way, not on top of your cells in your form.
Thu, 01 Mar 2018 16:00:00 GMT

The Amsterdam Excel Summit 2018: Dates are set!
Come and join us in Amsterdam on June 7 and 8, 2018 for our fifth famous Amsterdam Excel Summit. We have just fixed the dates so make sure you Visit the Amsterdam Excel Summit Website
Tue, 20 Feb 2018 16:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance of looking for dependents.
Wed, 15 Nov 2017 17:30:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed an issue caused by a Windows 10 bug. Renaming a name now also fixes hyperlinks using that name
Tue, 31 Oct 2017 10:50:00 GMT

Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 121. We have improved performance on a number of areas and added a way to report detailed statistics of multiple files.
Mon, 02 Oct 2017 17:05:00 GMT

New tool: Table Tools
I have added a new add-in to my site called Table Tools. This add-in makes your daily life with Excel tables a little simpler!
Wed, 20 Sep 2017 08:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the formula report
Mon, 18 Sep 2017 15:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance on analysing conditional formatting formulas
Tue, 15 Aug 2017 13:20:00 GMT

Nieuw artikel: Cocreatie in Office 365
Ik heb vandaag een nieuw artikel toegevoegd over Cocreatie in Excel 2016
Thu, 29 Jun 2017 07:00:00 GMT

New article: Co-authoring in Office 365
I have added a new article today about co-authoring in Excel 2016
Fri, 23 Jun 2017 16:00:00 GMT

Updated article: Declaring API functions in 64 bit Office
I have added a new Windows API function declaration for Office 64 bit to the list: URLDownloadToFile
Thu, 08 Jun 2017 17:15:00 GMT

Update to Flexfind
Updated: Flexfind. Flexfind was updated to build 592 in which I changed the default search scope to just the active workbook.
Wed, 7 Jun 2017 07:05:00 GMT

Access backup tool updated
I have updated my Access Backup utility so it now also orks on 64 bit Access.
Wed, 10 May 2017 08:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Finally fixed an intermittent issue with the Visualize functionality on Excel 2016
Mon, 08 May 2017 16:20:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance for Excel 2013 and 2016
Wed, 26 Apr 2017 14:20:00 GMT

Our Amsterdam Excel Summit was great
Our Amsterdam Excel Summit has been a great success. We had two very well received days full of Excel and Power BI sessions. Find links to photo impressions on my events page.
Tue, 25 Apr 2017 10:40:00 GMT

Update: Excel File Remediation Utility
Our Excel File Remediation Utility has just been updated. I have added an option to remove all styles from the workbooks. This is very useful if you have Excel files with corrupt styles.
Thu, 23 Mar 2017 15:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added jump to pivotsource when you trace precedents when in a pivottable.
Fri, 03 Mar 2017 13:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue regarding range names in formulas.
Sun, 19 Feb 2017 13:20:00 GMT

Update to Flexfind
Updated: Flexfind. Added support for replacing in Powerquery M code (Excel 2016).
Sat, 18 Feb 2017 19:10:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue with short-cut keys not responding immediately after openening Excel.
Wed, 15 Feb 2017 07:50:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug, Pivottables were not listed when pointing to a table name.
Thu, 9 Feb 2017 09:45:00 GMT

The Amsterdam Excel Summit 2017: Registration is open
Come and join us in Amsterdam on April 18 and 19 2017 for our famous Amsterdam Excel Summit. We have just opened registration so make sure you book your seats before Feb 20 and receive a nice early-bird discount! Visit the Amsterdam Excel Summit Website
Mon, 16 Jan 2017 16:20:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved scrolling the selected cells into the viewable area of the screen
Thu, 5 Jan 2017 06:25:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.
Wed, 14 Dec 2016 20:55:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fix for finding dynamic range names when using the Formulas or 2D areas filter.
Tue, 13 Dec 2016 15:20:00 GMT

New article: a Simple Inventory System, built in Excel
Answering questions on forums can be very rewarding. This post is the result of a forum question. The forum member needed a simple system to manage his shop inventory. He wanted to be able to log Purchases, Reservations and Sold items and immediately be kept informed when items are (almost) out of stock..
Tue, 11 Oct 2016 13:15:00 GMT

New article: A wheel of Fortune, built in Excel
Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. In this article I'll explain how I've built an Excel file which enables you to play with a wheel of fortune. With sound and all!.
Thu, 29 Sep 2016 17:45:00 GMT

New article: Excel add-ins fail to load
A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.
Wed, 17 Aug 2016 15:45:00 GMT

Updated: FollowCellPointer
I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.
Mon, 15 Aug 2016 09:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT

Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT

An MSForms (all VBA) listgrid.
Our All VBA treeview control now has a sister control: the ListGrid. This brand new control is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT

Register now: The Excel VBA Masterclass
We have just opened registration for The Excel VBA Masterclass. Course dates October 26 and 27, 2016.
Tue, 14 Jun 2016 14:10:00 GMT

Nieuw artikel: curves fitten met de kleinste kwadraten methode
Als je (net als ik, voordat ik Excel specialist werd) ingenieur bent, dan heb je waarschijnlijk het nodige aan experimeteerwerk gedaan. Vaak heb je dan een methode nodig om je meetresultaten te fitten met een kromme. En als je een echte ingenieur bent, dan heb je ook al een goed idee wat de soort vergelijking is de theoretisch bij ...
Tue, 12 Apr 2016 07:50:00 GMT

Nieuw artikel: Een klasse om VBA performance te meten
Ik ben er eindelijk aan toe gekomen een artikel te vertalen. Dit artikel beschrijft een methode om eenvoudig de performance van je VBA routines te meten.
Tue, 17 May 2016 07:50:00 GMT

Update to Flexfind
Updated: Flexfind. Improved selecting objects.
Thu, 21 Apr 2016 08:50:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved the off-sheet references report to include tables and range names.
Fri, 8 Apr 2016 15:50:00 GMT

New training: Excel VBA Mafsterclass
We have just published the course outline of our new training: Excel VBA Masterclass.
Mon, 29 Feb 2016 07:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added an off-sheet references report which visualises the inter-sheet formula links of your workbook.
Sat, 27 Feb 2016 15:35:00 GMT

Update to Flexfind
Updated: Flexfind. I have added support for searching and replacing in the first page headers and footers.
Thu, 04 Feb 2016 09:50:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an auto-update option.
Tue, 19 Jan 2016 08:25:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I fixed a small bug in getting values from entire columns. This is the last update for the Excel 2003 version of the add-in.
Tue, 15 Dec 2015 12:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I Improved the performance of finding dependents and improved how Objects are listed.
Wed, 25 Nov 2015 11:35:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I fixed a small bug causing a runtime error when you close Excel.
Wed, 07 Oct 2015 20:30:00 GMT

Tool to help close all Excel windows
With the new MDI interface introduced with Excel 2013, closing all workbooks has become unnecessary difficult. This little addin adds a 'Quit Excel' button to your File menu that will close all open workbooks and quit Excel. It also features a Short-cut key: control+q
Thu, 01 Oct 2015 09:30:00 GMT

Celebrating 30 years of Excel with 30 days 30% discount!
To celebrate the fact that Excel was launched 30 years ago (September 30, 1985) we're having an anniversary sale at jkp-ads.com. From September 30 to October 30, 2015 we offer a 30 % discount on both our products: RefTreeAnalyser and The ...
Thu, 01 Oct 2015 08:50:00 GMT

Solving problems with Office caused by Windows 10
I have just added a new chapter to my article on solving startup problems in Excel, especially for the people who are experiencing issues after upgrading their computer to Windows 10
Wed, 16 Sep 2015 13:35:00 GMT

Update to Flexfind
Updated: Flexfind. I have recently fixed a bug in Flexfind where the tool appears to make Excel 2013 unresponsive. The root cause of the problem was the new MDI interface of Excel which forced us to make the Flexfind window the topmost window, thus causing message boxes to appear behind the window in some situations.
Mon, 14 Sep 2015 10:05:00 GMT

Summer sale at jkp-ads.com
Yes we're having a summer sale at jkp-ads.com. From July 1 to July 10 we offer a 25 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility
Thu, 25 Jun 2015 06:15:00 GMT

New product: The Excel File Remediation Utility
I have launched a new product you can try and buy directly from my site: The Excel File Remediation Utility. This tool helps you to try and salvage Excel models with problematic content accumulated during a long editing history.
Thu, 25 Jun 2015 06:15:00 GMT

Registratie geopend: Excel VBA voor Financials V5
Excel VBA voor Financials versie 5; Een twee-daagse Excel VBA cursus (6, 14 en 21 oktober 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte!
Mon, 22 Jun 2015 15:45:00 GMT

Een nieuw Excel artikel: Bouwen van een invoegtoepassing voor Excel
Vandaag een artikel geplaatst over het maken van een invoegtoepassing in Excel. Alle stappen die je nodig hebt om een eenvoudige invoegtoepassing te maken worden erin beschreven.
Mon, 08 Jun 2015 15:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added support for hotkeys using the Alt key.
Wed, 06 May 2015 17:30:00 GMT

New Excel article: Building an Add-in for Excel
Today I posted an entirely new article. It describes all the steps needed to create a basic Excel add-in.
Mon, 04 May 2015 14:10:00 GMT

Link posted to Andrew's Excel Utilities
Today I posted a link to one of the most comprehensive sets of Excel productivity tools I have ever seen: Andrew's Excel Utilities
Tue, 07 Apr 2015 08:30:00 GMT

The Amsterdam Excel Summit 2015: Last minute discount
Our event is coming real soon now and we're very much looking forward to it. We have outstanding speakers and excellent content, so everything is lined up to make this a superb Excel event. To entice the undecisive Excel lovers to make up their minds and subscribe after all, we decided to make it even more attractive to attend. ...
Fri, 27 Mar 2015 08:20:00 GMT

The Amsterdam Excel Summit 2015: Great content!
Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early ...
Mon, 23 Feb 2015 14:40:00 GMT

Updated article: Working with Circular references in Excel
In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!
Wed, 11 Feb 2015 09:30:00 GMT

The Amsterdam Excel Summit 2015: Great content!
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! We have a lot of interesting subjects, including: Business Intelligence in Excel vNext, An introduction to Power Query, working with Excel charts less painful, Professionalising your Power Pivot Model, More efficient VBA UDFs, ...
Tue, 10 Feb 2015 17:20:00 GMT

Name manager updated
Name Manager for Excel has been updated. Improved renaming rangenames in VBA code.
Tue, 10 Feb 2015 17:20:00 GMT

The Amsterdam Excel Summit 2015: Registration is now open!
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. Make sure you register!
Thu, 22 Jan 2015 10:15:00 GMT

Registratie geopend: Excel VBA voor Financials V2
Excel VBA voor Financials versie 2; Een twee-daagse Excel VBA cursus (20 en 26 mei 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Tue, 30 Dec 2014 13:05:00 GMT

Update: GoBack.
Finally got some time to include an Excel 2007-2013 version of this little tool that traces where you went in your Excel files and gets you back easily!
Wed, 19 Nov 2014 06:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an option to report all unique formulas in your workbook. 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 be! Now there is the RefTreeAnalyser! ...
Thu, 23 Oct 2014 16:45:00 GMT

Celebrating my MVP award: Discount offer
Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. I got re-awarded! To celebrate that I am offering a 3 day 50 percent discount on RefTreeAnalyser. From October 8, 2014 to October 10, 2104 you receive 50 % off of the list price when you enter this coupon code: MVP2014 Head ...
Tue, 07 Oct 2014 09:30:00 GMT

Registratie loopt erg goed: Excel VBA voor Financials
Onze cursus Excel VBA voor Financials blijkt populari. Haast u als u mee wilt doen! Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Thu, 02 Oct 2014 16:00:00 GMT

Registratie geopend: Excel VBA voor Financials
Excel VBA voor Financials; Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Mon, 08 Sep 2014 15:35:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and added formula block highlighting. 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 be! Now there is the RefTreeAnalyser! ...
Fri, 20 Jun 2014 15:50:00 GMT

Commenting has been fixed
I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.
Mon, 02 Jun 2014 06:30:00 GMT

Update to Flexfind: Bugfix regarding replacing in cells with Values
My free Flexfind tool for Excel has been updated to build 584. Fixed a bug regarding replacing when search was done in Values.
Thu, 08 May 2014 09:35:00 GMT

Registratie sluit binnenkort! The Amsterdam Excel Summit 2014
Wees er nu echt snel bij, want de registratie sluit al op 7 mei! Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd ...
Mon, 28 Apr 2014 10:15:00 GMT

Registration closes soon! The Amsterdam Excel Summit 2014
Be quick to join us in Amsterdam on May 14 2014, for the registration on the first Amsterdam Excel Summit closes on May7th! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to ...
Mon, 28 Apr 2014 10:15:00 GMT

New page: A VBA performance class
I have added a new article to my site, describing a class module to help measuring your VBA performance.
Tue, 15 Apr 2014 17:15:00 GMT

Een nieuw artikel: Kringverwijzingen in Excel
Als je wel eens die vervelende melding hebt gehad over kringverwijzingen toen je een formule maakte of toen je een Excel bestand opende, lees dan dit nieuwe artikel. Excel detecteert een kringverwijzing zodra een reeks formules ertoe leidt dat dezelfde cel meer dan eens in serie berekeningen wordt aangedaan. Veel gebruikers vinden ...
Mon, 14 Apr 2014 11:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added hotkeys for Check Formulas and for Objects. 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 be! Now there is the RefTreeAnalyser! With this tool, finding ...
Thu, 03 Apr 2014 16:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved reporting and fixed a bug or two. 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 be! Now there is the RefTreeAnalyser! With this tool, finding out ...
Mon, 31 Mar 2014 17:30:00 GMT

New page: Pivottable Slicers, Showing selected Slicer items on a worksheet
I have added a new page to my article on Slicers, which shows you how to get the selected items of a slicer into a worksheet cell.
Fri, 21 Mar 2014 15:45:00 GMT

Update: Startup Problems
I have updated the page on Excel startup problems today with information about a newly discovered tool, the Office Configuration Analyzer Tool (OffCAT).
Thu, 20 Mar 2014 16:15:00 GMT

New page: Pivottable Slicers, Synchronising slicers
I have added a new page to my article on Slicers, which shows you how to synchronise slicers which drive different PivotCaches.
Thu, 13 Mar 2014 17:15:00 GMT

Aankondiging: The Amsterdam Excel Summit 2014
Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts ...
Thu, 13 Feb 2014 15:40:00 GMT

Anouncing: The Amsterdam Excel Summit 2014
Join us in Amsterdam on May 14 2014, for the first Amsterdam Excel Summit. An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. There is not much chance ...
Thu, 13 Feb 2014 15:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Prevented opening of unneeded blank workbook. 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 be! Now there is the RefTreeAnalyser! With this tool, finding out ...
Fri, 24 Jan 2014 13:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Made searching in Objects optional for searching precedents and dependents to improve performance. 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 be! Now there ...
Fri, 24 Jan 2014 13:40:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed a small bug introduced with searching in Objects. 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 be! Now there is the RefTreeAnalyser! With this tool, ...
Wed, 22 Jan 2014 14:10:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Now if you're tracing precedents or dependents objects (such as pivot tables, charts, data validation, Conditional formatting, ...) are also traced for cell dependencies. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel ...
Tue, 14 Jan 2014 08:20:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Now you can analyse all your Excel objects (such as pivot tables, charts, data validation, Conditional formatting, ...) for cell dependencies. 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 ...
Tue, 07 Jan 2014 17:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved placement of pictures of far-away cells. 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 be! Now there is the RefTreeAnalyser! With this tool, finding ...
Wed, 06 Nov 2013 12:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Visualisation colors can now be changed. 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 be! Now there is the RefTreeAnalyser! With this tool, finding out how ...
Fri, 01 Nov 2013 16:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Visualize precedents has been made available for Excel 2003 too. 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 be! Now there is the RefTreeAnalyser! With this ...
Wed, 30 Oct 2013 12:35:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added a new option to the tool: Visualize precedents. The precedents of a cell are visualised directly on the worksheet, a vast improvement on the built-in show precedents option. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large ...
Wed, 23 Oct 2013 16:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the reporting function. 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 be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell ...
Thu, 17 Oct 2013 16:10:00 GMT

Update to Flexfind: Bugfix regarding replacing dates
My free Flexfind tool for Excel has been updated to build 581. It now handles replacement of dates better.
Tue, 15 Oct 2013 15:25:00 GMT

A new tool: Trusted Documents Manager
I have just published a new tool today, Trusted Documents Manager. This little tool enables you to manage your list of trusted documents. Currently, Excel only allows you to either leave the list intact, or delete the entire list. This means all of your currently trusted documents become untrusted again so you have to enable macro's ...
Thu, 10 Oct 2013 13:30:00 GMT

Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control for Office has been updated to build 025. We've added a ControlTipText property and fixed a small bug regarding scrolling horizontally when checking a node.
Wed, 02 Oct 2013 12:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved tracing errors function. 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 be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell ...
Wed, 02 Oct 2013 09:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Small bugfix regarding handling of windows in Excel 2013. 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 be! Now there is the RefTreeAnalyser! With this tool, ...
Mon, 30 Sep 2013 10:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Important update: fixed some bugs in the multi-level precedents searching. 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 be! Now there is the RefTreeAnalyser! ...
Wed, 25 Sep 2013 10:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the error tracing and fixed a problem with the Stop button. 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 be! Now there is the RefTreeAnalyser! With ...
Mon, 23 Sep 2013 09:05:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (another messagebox was hidden from view by the appl. interface). 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 be! Now there is ...
Fri, 20 Sep 2013 13:30:00 GMT

Updated article: Keeping Userforms on top of SDI windows in Excel 2013 and up
The previous solution I developed for this problem had a serious drawback: messageboxes would show behind the userform. This new solution is simpler and does not have that problem.
Fri, 20 Sep 2013 13:30:00 GMT

Name manager updated
Name Manager for Excel has been updated. Improved window handling for Excel 2013.
Mon, 09 Sep 2013 17:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (messageboxes are hidden from view by the appl. interface). 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 be! Now there is the RefTreeAnalyser! ...
Wed, 28 Aug 2013 11:30:00 GMT

Name manager updated
Name Manager for Excel has been updated. Added Italian user interface language.
Wed, 21 Aug 2013 16:10:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved returning to the original selection after closing the tool. 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 be! Now there is the RefTreeAnalyser! With ...
Fri, 07 Jun 2013 13:00:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed some minor issues regarding use in Excel 2003. 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 be! Now there is the RefTreeAnalyser! With this tool, finding ...
Sun, 26 May 2013 10:20:00 GMT

Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control for Office has been updated to build 024. We have now included properly working examples for Word and Access!
Mon, 20 May 2013 14:10:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Now you can change the hotkeys. People who are using version 2 will be automatically prompted for this 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 ...
Fri, 03 May 2013 14:00:00 GMT

Queen's day sale: RefTreeAnalyser (version 2!) 50 percent rebate
Anyone who places an order between April 30, 2013, 8:00 AM GMT and May 1st, 2013 8:00 AM GMT will receive a 50 % rebate on the list price. I'm also going to give away some of the licenses: I'll randomly select 1 out of every 10 orders placed in that period of time These people will receive a complimentary license.
Mon, 29 Apr 2013 19:40:00 GMT

Koninginnedag uitverkoop: RefTreeAnalyser (version 2!) 50 procent korting
Koninginnedag uitverkoop! Alle bestellingen geplaatst tussen 30 april 10:00 's morgens en 1 mei 10:00 uur 's morgens (Nederlandse zomertijd) krijgen 50 procent korting. Bovendien verloot ik een gratis licentie per 10 geplaatste bestellingen.
Mon, 29 Apr 2013 19:40:00 GMT

Major Update: RefTreeAnalyser (version 2!)
RefTreeAnalyser has been completely updated to version 2.0. This new version also works on the 64 bit versions of Office. 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 be! Now there is the RefTreeAnalyser! ...
Wed, 24 Apr 2013 16:25:00 GMT

Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control for Office has been updated to build 021.
Thu, 14 Mar 2013 13:10:00 GMT

New article and download: An MSForms (all VBA) treeview.
We have created a treeview for Office VBA that will work on any version of Office as of Office 2000, including 64 bits and MAC Office! If you have ever used the Treeview control from the "Additional controls" section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems ...
Thu, 21 Feb 2013 14:30:00 GMT

Update to Autosafe
I've updated Autosafe with new translations for German.
Tue, 29 Jan 2013 15:30:00 GMT

Update: RefTreeAnalyser (build 1.0.31)
RefTreeAnalyser has been updated. I have changed how hidden sheets are handled (no more messageboxes). 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 ...
Wed, 02 Jan 2013 14:05:00 GMT

New article: Keeping Userforms on top of SDI windows in Excel 2013 and up
With the introduction of Excel 2013, Microsoft changed the windowing of Excel. On all previous versions, Excel had a so-called Multiple Document Interface (MDI), which means all open Excel files are hosted by one Excel application window. Excel 2013 introduced a Single Document Interface, meaning each workbook appears in its own ...
Mon, 26 Nov 2012 14:45:00 GMT

Update to Flexfind: Flexfind now handles Excel 2013 new SDI interface
My free Flexfind tool for Excel has been updated to build 577. It now properly keeps its dialog on top of all Excel 2013 windows.
Wed, 21 Nov 2012 14:55:00 GMT

Update to Flexfind: Bugfix regarding non-English formulas
My free Flexfind tool for Excel has been updated to build 575. Fixed a problem with searching in Forumlas in non-English versions of Excxel.
Tue, 13 Nov 2012 16:35:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed a small issue with regards to updating the LinkedCell property when renaming.
Thu, 21 Jun 2012 06:20:00 GMT

New tool: ControlLister.
I have added my control lister to my download page today, this tool lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table.
Thu, 14 Jun 2012 16:30:00 GMT

Updated article: Declaring API functions in 64 bit Office
I have added a couple of new Windows API function declarations for Office 64 bit to the list.
Wed, 06 Jun 2012 18:45:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code. Now it also handles range names in square brackets such as [TheName].
Mon, 4 Jun 2012 08:20:00 GMT

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

Updated article: Installing An Excel Add-in Using Setup Factory
I have updated my article that describes how to use Setup Factory to install an addin. Special thanks to Emiel Nijhuis of www.delegate.nl for suggesting some fixes.
Tue, 22 Nov 2011 06:40:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code.
Mon, 26 Sep 2011 12:45:00 GMT

New tool: ExportVBAProject
This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.
Thu, 15 Sep 2011 15:45:00 GMT

Nieuwe tool: ExportVBAProject
Met deze utility kan je alle VBA componenten van werkmap A exporteren naar één tekst bestand. Handig als je de inhoud van twee versies van een VBA project wil vergelijken.
Thu, 15 Sep 2011 15:45:00 GMT

Update to Autosafe
I've updated Autosafe so it now also works in 64 bit Excel 2010.
Mon, 29 Aug 2011 11:00:00 GMT

New article: Batchprocessing: how to calculate your model with many input values
I have added a new article to my website (courtesy Niek Otten). Introduction of the article: Sometimes you want to apply an existing worksheet calculation to many sets of data rather than just the one case for which it was designed. For example, you developed a worksheet which calculates your pension. It accepts some twenty input ...
Thu, 25 Aug 2011 13:05:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed a small issue with regards to the larger grid in Excel 2007 and 2010.
Thu, 07 Jul 2011 13:05:00 GMT

Updated article: Declaring API functions in 64 bit Office
I have added a link to a download by Microsoft listing many win64 API declarations.
Thu, 12 May 2011 09:05:00 GMT

Updated article: Declaring API functions in 64 bit Office
I have added a couple of new Windows API function declarations for Office 64 bit to the list.
Thu, 03 Mar 2011 07:15:00 GMT

Update to Flexfind: 64 bit enabled
My free Flexfind tool for Excel has been updated to build 570. Flexfind now also works in 64 bit Excel 2010.
Thu, 17 Feb 2011 07:45:00 GMT

Name manager updated
Name Manager for Excel has been updated. When deleting a name, Name Manager now offers to un-apply the name in your workbook.
Tue, 15 Feb 2011 16:45:00 GMT

Name manager bijgewerkt
Name Manager for Excel is bijgewerkt. Bij verwijderen van bereiknamen worden deze nu op verzoek in je formules omgezet naar hun oorspronkelijke verwijzingen.
Tue, 15 Feb 2011 16:45:00 GMT

Update to Flexfind: Now finds Error values if your Excel is NOT in English
My free Flexfind tool for Excel has been updated to build 569. Flexfind now finds Error values like #NUM! if your Excel is NOT in English.
Mon, 14 Feb 2011 07:45:00 GMT

New page: Pivottable Slicers
Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article ...
Wed, 12 Jan 2011 13:45:00 GMT

New page: Software reviews
Sometimes I review a piece of software. I decided these deserve a special place on my website, so here is the first one: Setup Factory.
Mon, 03 Jan 2011 07:45:00 GMT

Update to Flexfind: S&R for alt+010
My free Flexfind tool for Excel has been updated to build 568. Flexfind can now handle characters like alt+010.
Tue, 14 Dec 2010 06:35:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fixed a compile error Office 2010 64 bit users were experiencing.
Tue, 23 Nov 2010 08:45:00 GMT

Name manager updated
Name Manager for Excel has been updated. I finally fixed an odd compile error that only happened for a few of my users.
Thu, 18 Nov 2010 05:25:00 GMT

Updated: Query Manager
I have finally gotten round to updating the Query Manager so you can use it to update the connection and commandtext of pivot caches using external data.
Thu, 23 Sep 2010 09:20:00 GMT

A new tool: FollowCellPointer
I have just published a small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your cell formatting.
Wed, 08 Sep 2010 15:50:00 GMT

Een nieuw tooltje voor Excel: FollowCellPointer
Ik heb zojuist een nieuw tooltje geplaatst, dat je cel aanwijzer makkelijker te vinden maakt door er met een horizontale en vertikale pijl naar te wijzen.
Wed, 08 Sep 2010 15:50:00 GMT

Updated article: Preventing auto_open and Workbook_Open events from running
Seems the methods I described to prevent the workbook_Open event do not always work for Excel 2007.
Thu, 08 Jul 2010 20:00:00 GMT

Name manager version 4.2 released
Name Manager for Excel has been updated to version 4.2 with quite a number of updates.
Thu, 01 Apr 2010 17:50:00 GMT

Name manager version 4.2 gepubliceerd
Name Manager voor Excel, versie 4.2 is gepubliceerd, met aardig wat nieuwe mogelijkheden.
Thu, 01 Apr 2010 17:50:00 GMT

Name manager goes 64 bit!
My free Name Manager for Excel has been updated to build 616 so it now works on 64 bit Excel 2010 too. This means there is a version of Name Manager for all versions of Excel, starting with Excel 97.
Thu, 01 Apr 2010 07:20:00 GMT

Excel opstart problemen pagina bijgewerkt
De pagina is bijgewerkt voor de Excel versies 2007 en 2010.
Mon, 22 Mar 2010 08:40:00 GMT

New article: Importing Text Tiles In An Excel sheet
If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't set up how it gets imported. The text import wizard does not start for these file types. What if you have the situation where you get files with similar structure, which need ...
Thu, 11 Mar 2010 09:00:00 GMT

Access backup tool updated
I have updated my Access Backup utility so it no longer errors on linked tables. Also, it now copies the relationships too.
Wed, 03 Feb 2010 09:45:00 GMT

New article: Declaring API functions in 64 bit Office
With the introduction of Windows 7 and Office 2010 VBA developers face a new challenge: ensuring their applications work on both 32 bit and 64 bit platforms. This page is meant to become the first stop for anyone who needs the proper syntax for his API declaration statement in Office VBA.
Thu, 28 Jan 2010 12:05:00 GMT

Nieuw artikel: Voorkomen dat auto_open en Workbook_Open events worden uitgevoerd.
Omdat ik software ontwikkelaar ben, komt het regelmatig voor dat ik een Excel bestand wil openen met de macro's ingeschakeld. Tegelijkertijd wil ik daarbij soms voorkomen dat het Workbook_Open event of de Auto_Open macro wordt uitgevoerd. In dit artikel laat ik zien hoe dit in de verschillende Excel versies kan worden gedaan.
Mon, 11 Jan 2010 08:20:00 GMT

Updated article: Registering a User Defined Function with Excel.
To enable showing argument descriptions for Excel User Defined Functions (UDF), we had to go through many hoops and use wizardry and trickery. Excel 2010 has now enabled us to use a plain and simple VBA command to do exactly that. I have updated the article to include a how-to for Excel 2010.
Wed, 06 Jan 2010 06:40:00 GMT

New article: Using controls on worksheets
Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your sheet to offer choices to the user. Moreover, you can add scroll bars and spinners to quickly control values in cells. These elements ...
Tue, 29 Dec 2009 09:15:00 GMT

New article: Preventing auto_open and Workbook_Open events from running
As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. This little article shows you how to achieve that.
Mon, 07 Dec 2009 13:20:00 GMT

Nieuw artikel: Het gebruik van Besturingselementen
Naast invoercellen die zijn gekoppeld aan cellen met formules, beschikt Excel over nog meer mogelijkheden om een werkblad interactief te maken. Zo is het mogelijk om aan een werkblad keuzerondjes, selectievakjes, tekstvakjes en dergelijke toe te voegen. Deze elementen worden ook wel besturingselementen genoemd, omdat ze de gebruiker ...
Mon, 23 Nov 2009 13:10:00 GMT

Update to Flexfind: S&R in textboxes
My free Flexfind tool for Excel has been updated to build 563. Flexfind can now handle textboxes with more than 255 characters of text.
Tue, 17 Nov 2009 06:35:00 GMT

Update: RefTreeAnalyser (build 1.0.26)
RefTreeAnalyser has been updated. RefTreeAnalyser now does not error out when started whilst editing a cell.
Thu, 05 Nov 2009 10:40:00 GMT

Update: RefTreeAnalyser (build 1.0.25)
RefTreeAnalyser has been updated. It now shows a small message when no references have been found.
Fri, 02 Oct 2009 15:30:00 GMT

Name manager update: bugfix to enable Name Manager to work on Excel 2010
My free Name Manager for Excel has been updated to build 613, with a bugfix related to Excel 2010.
Wed, 30 Sep 2009 15:00:00 GMT

Name manager update: Added the possibility to add local names to each worksheet
My free Name Manager for Excel has been updated to build 610. I have added the possibility to add local names to each worksheet using the Add Names dialog. In addition, Name Manager is now fully Excel 2010 compatible!
Wed, 22 Jul 2009 13:30:00 GMT

Update: RefTreeAnalyser (build 1.0.24)
RefTreeAnalyser has been updated to fix a small bug related to using the stop button.
Fri, 17 Jul 2009 14:55:00 GMT

Name manager update: Some minor bug fixes applied
My free Name Manager for Excel has been updated to build 608. Fixed some minor bugs.
Mon, 13 Jul 2009 07:10:00 GMT

Update to: Using Parameters With Web Queries
Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on the values in so called ...
Thu, 09 Jul 2009 08:30:00 GMT

Update to Autosafe
I've updated Autosafe so it stays quiet as long as the system has been used within the last 30 seconds. After 4 skips it will do a save even though you're busy.
Mon, 25 May 2009 08:10:00 GMT

New article: The New Excel 2007 File Format; Adding RibbonX code to an Office OpenXML file using VBA
Previously, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, a couple of modifications were needed to the code in the class module I showed earlier. Fellow Excel MVP Ken Puls was kind enough to make ...
Mon, 18 May 2009 18:30:00 GMT

New article: The New Excel 2007 File Format; Editing elements in an OpenXML file using VBA
Wouldn't it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.
Wed, 06 May 2009 18:00:00 GMT

Update: RefTreeAnalyser (build 1.0.23)
RefTreeAnalyser has been updated to fix a small bug related to protected worksheets.
Mon, 04 May 2009 06:25:00 GMT

Nieuw artikel: Werken met tabellen in Excel 2007
Excel 2007 is de eerste Excel versie in lange tijd die vele vernieuwingen bevat. Eén daarvan is de verbetering in de manier waarop Excel om kan gaan met gegevens tabellen. De functionaliteit (Tabellen genaamd) is in wezen een uitbreiding op de lijsten die Excel 2003 al kent. Dit artikel introduceert deze nieuwe functionaliteit en ...
Tue, 28 Apr 2009 08:10:00 GMT

Nieuw artikel: Koppelingen naar UDFs in Addins herstellen
Excel heeft honderden ingebouwde functies die je helpen bij het doen van allerlei berekeningen. Maar soms is het handiger om een zelfgemaakte functie te bouwen in VBA. Dergelijke functies worden ook wel "User Defined Function" genoemd, UDF. UDF's worden normaal gesproken hetzij in het bestand gezet waarin ze nodig zijn, hetzij in ...
Fri, 24 Apr 2009 11:00:00 GMT

Nieuw artikel: Het nieuwe Excel 2007 bestandsformaat
Excel 2007 (Office 2007) heeft een nieuw bestandsformaat, gebaseerd op wat Microsoft het Open XML formaat noemt. Dit nieuwe formaat geeft ons de mogelijkheid om programmacode te schrijven, die Office 2007 bestanden kan genereren en/of wijzigen, zonder dat Office daarvoor hoeft te zijn geinstalleerd. Bijvoorbeeld op een (web-)server. ...
Wed, 22 Apr 2009 08:15:00 GMT

Update: RefTreeAnalyser (build 1.0.21)
RefTreeAnalyser has been updated with a new feature: The tool now handles Excel 2007 structured references to tables. 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 ...
Mon, 30 Mar 2009 15:15:00 GMT

Bijgewerkt: RefTreeAnalyser (build 1.0.21)
RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont nu ook gestructureerde verwijzingen naar Excel 2007 tabellen. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan ...
Mon, 30 Mar 2009 15:15:00 GMT

Name manager update: Added Finnish language
My free Name Manager for Excel has been updated to build 606. No bug fixes, just added the Finnish language.
Sun, 22 Feb 2009 11:30:00 GMT

Update to Fixing Excel problems page
I've added some information on solving Excel trouble caused by corruptions in Excel's registry key.
Wed, 18 Feb 2009 11:50:00 GMT

Excel problemen pagina bijgewerkt
De pagina is bijgewerkt met nieuwe informatie over het oplossen van een register probleem van Excel.
Wed, 18 Feb 2009 11:50:00 GMT

New article: Styles in Excel
This article explains how you can use styles to ease maintenance of your spreadsheet models. Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done in an ad-hoc manner, many spreadsheet pages look messy. By consistently using ...
Thu, 05 Feb 2009 16:30:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser has been updated with a new feature: The tool now shows the trace arrows of the currently selected cell. 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 ...
Thu, 29 Jan 2009 08:25:00 GMT

Bijgewerkt: RefTreeAnalyser
RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont de verwijzingspijlen van de huidige geselecteerde cel. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet ...
Thu, 29 Jan 2009 08:25:00 GMT

Nieuw artikel: Opmaakprofielen in Excel
Dit artikel laat zien hoe je gebruik kunt maken van Excel's opmaakprofielen om het onderhoud aan een spreadsheet te vergemakkelijken. Het is maar al te gemakkelijk om een werkblad te verfraaien met allerlei kleurtjes, kadertjes en andere tierelantijntjes. Omdat deze formatterings werkzaamheden vaak ad-hoc gebeuren, veroorzaakt dit ...
Thu, 29 Jan 2009 07:30:00 GMT

Update to Autosafe
I've updated Autosafe to cater for illegal filenames which may result from downloading files. Please note that if you're using build 119, the autoupdate function causes an error. 119 users are advised to download autosafe manually:
Mon, 26 Jan 2009 17:40:00 GMT

Nieuw artikel: Kolom breedtes in een ListBox automatisch aanpassen
Laatst had ik in een project een snelle methode nodig om de inhoud van een matrix aan de gebruiker te tonen. Ik wilde hiervoor geen werkblad gebruiken, maar koos voor een Userform. Dus bedacht ik dat ik een listbox wilde gebruiken waarvan de kolombreedtes zich aan de gegevens zouden aanpassen. Dat bleek helemaal zo eenvoudig nog niet...
Mon, 19 Jan 2009 18:00:00 GMT

Brand new Access tool: backup databases which are in use
My very first Access tool has been published today: Do you have one or more databases which are permanently in use? Then you probably know you can't just copy their files to create a backup of them as they might become corrupt. This database tool lets you schedule backups for an unlimited amount of Access databases. The tool keeps ...
Thu, 18 Dec 2008 13:05:00 GMT

Een nieuwe Access tool: backup databases die in gebruik zijn
Heeft u een of meer databases die permanent in gebruik zijn? Dan weet u wellicht, dat u niet zonder meer een backup van deze bestanden kunt maken terwijl ze in gebruik zijn: de kopien kunnen corrupt zijn. Deze database tool geeft de mogelijkheid om een ongelimiteerd aantal databases in een in te stellen frequentie te laten kopieren. ...
Thu, 18 Dec 2008 13:05:00 GMT

Update to Autosafe
I've updated Autosafe to fix a small bug in the update process that affected Excel 2007.
Thu, 27 Nov 2008 08:05:00 GMT

New article: XML and Excel
Microsoft Office 2003 Professional was the first Office version that took the XML standard seriously. The XML standard has been devised to ease the markup of data (especially on the web). A well known example of the use of XML are RSS feeds with which one can gather news from web pages. In reality, these so-called RSS-feeds are ...
Thu, 20 Nov 2008 14:25:00 GMT

Update to Autosafe
I've updated Autosafe to include the Korean language and fixed a small bug that made Autosafe pickup backup copies of other Excel sessions.
Wed, 12 Nov 2008 06:05:00 GMT

5th anniversary and all new website!!
Already 5 years have passed since I founded my company. And I must say those years passed in the blink of an eye. I've never enjoyed my work as much as in these past years. Along with this fifth anniversary comes a new website look and feel. Come and have a look!!
Wed, 05 Nov 2008 19:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser has been updated a minor bugfix regarding screen resizing. 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 be! Now there is ...
Mon, 20 Oct 2008 12:10:00 GMT

Bijgewerkt: RefTreeAnalyser
RefTreeAnalyser is bijgewerkt met een kleine bugfix met betrekking tot het veranderen van de schermgrootte. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie ...
Mon, 20 Oct 2008 12:10:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser has been updated a minor bugfix regarding duplicate operators in formulas such as >=. 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 ...
Thu, 25 Sep 2008 18:44:00 GMT

Name manager update: Fixed a few issues
My free Name Manager for Excel has been updated to build 604. A tiny issue was fixed.
Wed, 17 Sep 2008 11:10:00 GMT

Update to Flexfind: Fixed a few issues
My free Flexfind tool for Excel has been updated to build 560. I've fixed a bug in searching and replacing in chart series.
Mon, 11 Aug 2008 18:45:00 GMT

New article: Fixing Links To UDFs in Addins
Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called "User Defined Functions" (UDF). UDFs typically are placed in addins. As long as the addin is installed, the UDFs work as expected. You get into trouble when the location ...
Mon, 02 Jun 2008 18:15:00 GMT

New article: Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved ...
Wed, 14 May 2008 18:15:00 GMT

Update: Name Manager (version 4.1, build 603)
Updated Name Manager: Fixed a bug: when hidden name is edited, it used to become unhidden. When one adds names and the filter is set to show hidden names, new names are hidden by default.
Tue, 13 May 2008 18:45:00 GMT

Update: Name Manager (version 4.1, build 602)
Updated Name Manager: Fixed a bug in the used names filter avoiding false positives on names which resemble a column reference.
Tue, 13 May 2008 08:00:00 GMT

Update: SetupUtility
Updated SetupUtility: Accounted for the fact the Application.UserLibraryPath does contain a trailing pathseparator, unlike any other path in Excel's object model.
Tue, 06 May 2008 10:55:00 GMT

Update: Name Manager (version 4.1, build 600)
Updated Name Manager: Fixed a bug in the Areas filter.
Wed, 23 Apr 2008 15:45:00 GMT

Update to Flexfind: Improved Userinterface
My free Flexfind tool for Excel has been updated to version 5.3, build 558. I've improved the UI and the selecting of found items.
Fri, 28 Mar 2008 13:45:00 GMT

Update: Name Manager (version 4.1, build 599)
Updated Name Manager: I've Updated the unused names filter to include objects and VBA and fixed a bug affecting Excel 2000 users only.
Fri, 28 Mar 2008 13:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser has been updated with hotkeys and improved reporting. 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 be! Now there is the ...
Mon, 10 Mar 2008 08:10:00 GMT

Update: Name Manager (version 4.1, build 595)
Updated Name Manager: Fixed a bug regarding editing a name in R1C1 mode and changed the way the create name dialog works.
Wed, 13 Feb 2008 18:15:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser has been updated with a help file and is now accessible through the cell rightclick menu. 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 ...
Wed, 13 Feb 2008 06:10:00 GMT

Update: Name Manager (version 4.1, build 594)
Updated Name Manager: Removed a control on a form that caused compile errors for some users.
Fri, 18 Jan 2008 19:25:00 GMT

New page: Catching Paste Operations
You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find reliable is to catch all possible paste operations. But this isn't very easy, since ...
Mon, 17 Dec 2007 18:10:00 GMT

New page: Excel Headlines
Now in one convenient place: the most recent references to articles from what I think are the most important Excel Blogs in the world.
Fri, 07 Dec 2007 18:10:00 GMT

Update: Name Manager (version 4.1, build 590)
Updated Name Manager to add a tiny but very useful toolbar to the VBE, which enables you to select from available range names and paste into your code.
Thu, 06 Dec 2007 18:00:00 GMT

Bijgewerkt: Name Manager (versie 4.1, build 590)
De Name Manager is uitgebreid met een o zo handig toolbartje waarmee je in de Visual Basic Editor een bereiknaam kunt selecteren in in je code laten plakken.
Thu, 06 Dec 2007 18:00:00 GMT

New Tool: RefTreeAnalyser
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 be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Mon, 03 Dec 2007 10:55:00 GMT

Een nieuwe Tool: RefTreeAnalyser
Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn.! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere ...
Mon, 03 Dec 2007 10:55:00 GMT

Update to: Working with Tables in Excel 2007
I just learnt that using a table from workbook 1 in workbook 2 requires a special syntax. I have updated the article so it includes this information.
Wed, 14 Nov 2007 07:35:00 GMT

Update to Flexfind: bugfix
My free Flexfind tool for Excel has been updated to build 552. Fixed problems with using wildcard search and replace.
Mon, 08 Oct 2007 14:15:00 GMT

Een artikel op de Nederlandse "Microsoft voor ondernemers" website.
Dit artikel is onlangs (in het Nederlands) geplaatst op de website "Microsoft voor ondernemers". De link naar het artikel op de Microsoft site vindt u op bij het artikel op mijn site.
Fri, 28 Sep 2007 10:37:00 GMT

Published an article on the Dutch Microsoft Company website.
This article of mine was recently published (in Dutch of course) on the Dutch Microsoft website. The link to the MSFT site is mentioned at the top of the article.
Fri, 28 Sep 2007 10:37:00 GMT

Update: Name Manager (build 588)
Updated Name Manager to fix a small bug. Now pivot table source ranges are updated when renaming a name.
Tue, 18 Sep 2007 07:00:00 GMT

Bijgewerkt: Name Manager (build 588)
Name Manager is bijgewerkt naar build 588 waarmee een kleine bug is gefixt. Nu worden de bronbereiken van draaitabellen ook aangepast bij het hernoemen van een bereiknaam.
Tue, 18 Sep 2007 07:00:00 GMT

Update: CopyVBAProject for Excel VBA (build 005)
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 005: Fixed not copying class modules.
Tue, 11 Sep 2007 15:45:00 GMT

Update to Flexfind: bugfix
My free Flexfind tool for Excel has been updated to build 551. Fixed some problems with searching in protected worksheets.
Wed, 08 Aug 2007 17:30:00 GMT

Update: CopyVBAProject for Excel VBA (build 004)
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 004: Existing modules are overwritten in stead of added.
Mon, 06 Aug 2007 17:05:00 GMT

Update to AutosafeVBE: bugfix
My free AutosafeVBE for Excel has been updated to build 026. Important fixes for the Excel version are included, so users are recommended to download.
Mon, 06 Aug 2007 07:35:00 GMT

New article: The New Excel 2007 File Format; Changing properties of Form controls
On this page I explain how you can change properties of form controls on worksheets by editing the xml inside an Excel file's internals directly.
Fri, 08 Jun 2007 18:25:00 GMT

New download: CopyVBAProject for Excel VBA
This utility enables you to copy the components from the VBAProject of workbook A to Workbook B.
Fri, 01 Jun 2007 18:25:00 GMT

Update to Flexfind: bugfix
My free Flexfind tool for Excel has been updated to build 550. Important fix: When replacing text in Values, previous builds would also replace in cells with a formula. Build 550 fixes that issue.
Thu, 31 May 2007 09:15:00 GMT

The New Excel 2007 File Format, Working With Worksheet Data In An Excel 2007 File
On this new page I'll explain how you can read and write to a cell on a worksheet by editing the xml inside an Excel file's internals directly.
Thu, 17 May 2007 15:15:00 GMT

Listing an Object's Properties and Methods
If you do some VBA programming regularly, you'll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project). Whilst this is a tremendous tool to look for information on just a couple of properties ...
Mon, 14 May 2007 14:00:00 GMT

Working with Tables in Excel 2007 (VBA)
In "Working with Tables in Excel 2007" I promised to add a page about working with those tables in VBA too. Well, here you go.
Fri, 27 Apr 2007 18:45:00 GMT

Update: Updating an Excel Addin Through the Internet
I have updated this article because I got some reports on problems with Excel 2007.
Mon, 23 Apr 2007 10:20:00 GMT

Excel VBE Multiline Search And Replace.
Sometimes I want to automate the editing of some parts of my VBA code. One thing I wantd to do lately, was search for mutliple of lines of codes (and of course replace them with new lines). I've now released a tool that enables you to do just that!
Thu, 12 Apr 2007 15:30:00 GMT

Books on Excel.
Since I revised an Excel VBA book, I decided it was time to add a page on books on Excel to my website. The page only lists this one book for now, but I intend to add more in the coming weeks.
Tue, 03 Apr 2007 08:30:00 GMT

Installing An Excel Add-in Using Setup Factory.
This article first shows how Excel manages addins in the registry. Then it shows scripts how to do this during a setup routine using the program called Setup Factory. Being an MVP has some benefits. One of them is that some software companies offer Not For Resale (NFR) products to them for free. Of course these companies hope the ...
Wed, 21 Mar 2007 09:10:00 GMT

Autosafe Update: Auto-update included.
I've updated Autosafe to include the 'updating of an addin' method I described earlier.
Tue, 20 Mar 2007 13:10:00 GMT

Updating an Excel Addin Through the Internet
If you have created a nice add-in, an updating mechanism is an easy way to ensure your users get any bugfixes you did automatically . This article demonstrates how you can implement this functionality in your addin.
Mon, 19 Feb 2007 09:10:00 GMT

Update to Fixing Excel problems page
I've added some information on troubleshooting startup trouble caused by COM addins.
Fri, 09 Feb 2007 17:40:00 GMT

Pagina bijgewerkt: Excel opstart Problemen oplossen
Toegevoegd is een aantal tips om problemen veroorzaakt door COM invoegtoepassingen te onderzoeken.
Fri, 09 Feb 2007 17:40:00 GMT

Announcing: Release of Autosafe 3.5
Autosafe is now freeware. Autosafe backs up your work in Excel. When you restart Excel after a crash, you're offered to restore backed up copies of your files. You can also restore previous backup copies from your recycle bin to revert back to an older version of your work. This new version of Autosafe will work with long path+filenames ...
Thu, 01 Feb 2007 09:31:00 GMT

Update to article 'Creating An Add-in From An Excel Macro.'
With the release of Office 2007, everything has changed regarding user interface programming in Excel. I've updated my set of articles on distributing macros today, with special sections on Excel 2007 where appropriate.
Fri, 26 Jan 2007 11:50:00 GMT

Name Manager 4.0: Bugfix
Build 580 of Name Manager fixes a rarely occuring problem which prevented it from loading, showing an "Invalid Picture" error.
Thu, 18 Jan 2007 08:10:00 GMT

Working with Data Tables in Excel 2007
With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data. This new functionality is (not surprisingly) called "Data Tables". This article introduces you into the concepts of working with Data Tables and shows you how they may help you in your everyday Excel use.
Fri, 12 Jan 2007 13:30:00 GMT

Flexfind for Excel 2007
I've added an Excel 2007 version of Flexfind. Only change: inserts a control on the ribbon for easy access.
Tue, 19 Dec 2006 08:40:00 GMT

Dokken van vensters in de VBE
Als je net zoals ik een VBA programmeur bent, dan vindt je het wellicht ook belangrijk hoe de verschillende vensters van de Visual Basic Editor zijn geplaatst. Soms maakt de VBE er een rommeltje van en het kan op zijn zachtst gezegd een uitdaging zijn om ze weer allemaal op hun plekje te krijgen. In dit artikeltje laat ik je zien ...
Fri, 15 Dec 2006 15:45:00 GMT

Fixing Docking Of Windows In The VBE
If you're a VBA programmer like me, you're probably picky about your window arrangements in the Visual Basic Editor. Sometimes it messes things up and it can be a challenge to get those windows where you want them. Here are some tips to get things back in order.
Wed, 06 Dec 2006 18:00:00 GMT

Name Manager 4.0: Another Bugfix
Build 577 of Name Manager fixes a small bug related to renaming local names.
Wed, 29 Nov 2006 15:45:00 GMT

Name Manager 4.0 for Excel 2007 RTM: Released
I have uploaded an Excel 2007 RTM version of Build 576 of Name Manager today.
Fri, 24 Nov 2006 10:15:00 GMT

Name Manager 4.0: Another Bugfix
Build 576 of Name Manager fixes a small bug related to use of Name Manager in an Office MUI language situation. Added functionality: delete names by pressing the del key.
Wed, 15 Nov 2006 14:00:00 GMT

Name Manager 4.0: Small Bugfix
Build 575 of Name Manager fixes a small bug related to renaming a name which is not in use.
Sat, 04 Nov 2006 15:04:00 GMT

Announcing: Beta version of Autosafe 3.5
This new version of Autosafe will work with long path+filenames (previous versions didn't).
Fri, 27 Oct 2006 12:15:00 GMT

Aankondiging:: Beta versie van Autosafe 3.5
Deze versie maakt gebruik van Autosafe mogelijk in situaties met lange bestands en padnamen.
Fri, 27 Oct 2006 12:15:00 GMT

Announcing: Name Manager 4.0 for Excel 2007
For those of you who are using and testing Excel 2007 (Beta 2), Name Manager for Excel 2007 is available on this page.
Mon, 18 Sep 2006 10:40:00 GMT

Transposing the Formulas in a Table of Cells
Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.
Fri, 15 Sep 2006 18:00:00 GMT

De formules in een tabel transponeren
Recentelijk vroeg mij iemand of het mogelijk is om een tabel met cellen te transponeren, zodanig dat de formule van elke cel intact blijft. Ik besloot dat VBA de aangewezen weg was om dit te bereiken en heb een kleine maar handige subroutine gemaakt die dat doet.
Fri, 15 Sep 2006 18:00:00 GMT

Announcing: Excel Name Manager 4.0 Released
New features: 1. Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. 2. View where name is in use. A treeview shows all locations where a name is used, including VBA code.
Mon, 12 Jun 2006 18:40:00 GMT

Excel Name Manager 4.0 is nu beschikbaar
Nieuwe mogelijkheden: 1. Hernoem een naam. Name Manager geeft u nu de mogelijkheid om een naam te hernoemen. Hierbij worden alle formules die gebruik maken van die naam ook bijgewerkt, evenals mogelijke objecten (grafieken, besturingselementen e.d.); 2. Toon waar een naam precies in gebruik isinclusief in uw VBA code.
Mon, 12 Jun 2006 18:40:00 GMT

Nieuw artikel: Een bereik laten selecteren door de gebruiker (VBA, Bug in Application.InputBox functie).
De Application.InputBox functie is zeer handig om een bereik door de gebruiker te laten selecteren, waarmee vervolgens in de VBA code verder gewerkt kan worden. Helaas bevat deze functie een bug (all huidige Excel versies hebben deze bug). Wanneer er op het werkblad waarop een bereik wordt geselecteerd voorwaardelijke opmaak is ...
Tue, 30 May 2006 17:30:00 GMT

New page: NavigatorXL: Business Intelligence with Oracle and Excel Made Easy.
NavigatorXL ends the spreadsheet chaos and smoothens the path for really value-added business intelligence solutions. With NavigatorXL you can: Distribute updated spreadsheets throughout your business organization. Secure your spreadsheets so department managers are only allowed to see their department's data. Combine multiple data ...
Sun, 21 May 2006 14:50:00 GMT

Update to Setup utility.
If you have created a nice add-in, a setup utility is an easy way for your users to install your addin. This free utility just needs you to change 4 cells to roll your own setup file. Update: Now automatically removes invalid addins from addin list (courtesy: Richard Reye).
Thu, 11 May 2006 08:45:00 GMT

New Article: Getting a range from the user with VBA (Bug in Application.InputBox function)
The Application.InputBox function is very useful to get a range from the user. Unfortunately, this function exposes a bug in Excel (all current versions!). If the sheet on which a (range of) cell(s) is selected contains conditional formatting using the : "Formula Is" option, the function may fail, returning an empty range.The only ...
Thu, 04 May 2006 10:30:00 GMT

Update: Excel Name Manager 4.0 Beta new build
I have fixed a couple of bugs in Beta 4 of the Name Manager (build 554).
Thu, 04 May 2006 10:20:00 GMT

Update: Excel Name Manager 4.0 Beta new build
I have fixed a couple of bugs in Beta 4 of the Name Manager (build 550) and added a feature: show a list of all places where a name is in use.
Fri, 28 Apr 2006 10:45:00 GMT

Announcing: Excel Name Manager 4.0 Beta
New feature: Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. This new feature has yet to be tested thoroughly though, so that is why this version is still in Beta stage. Test drive version 4 and report any problems to me.
Tue, 11 Apr 2006 09:00:00 GMT

XML en Excel 2003
Microsoft Office 2003 Professional is de eerste Office versie die de XML standaard echt serieus neemt. De XML standaard is ingesteld om het markeren van gegevens (met name op het web) te vergemakkelijken. De standaard vindt steeds meer toepassing. Een bekend voorbeeld zijn RSS feeds waarmee men nieuws kan vergaren van internet pagina's. ...
Wed, 05 Apr 2006 07:00:00 GMT

Undo mogelijk maken voor macro's in Excel VBA
In Microsoft Word kan men wijzigingen die door VBA code in een document worden aangebracht standaard ongedaan maken. In Excel is dit helaas niet het geval. Vrijwel alle macro commando's legen de Undo "stack" en de acties zelf kunnen niet meer ongedaan worden gemaakt. Om dit toch mogelijk te maken, moet men code schrijven die: De ...
Tue, 04 Apr 2006 08:20:00 GMT

Update to AutosafeVBE
A heads-up to all VBA developers. I've just updated AutosafeVBE, the utility that backups your VBA projects. Now handles up to 9999 generations!
Thu, 23 Mar 2006 18:40:00 GMT

Creating An Undo Handler To Undo Changes Done By Excel VBA
Unlike Word, changes made to an Excel workbook by using VBA cannot be undone easily. One has to write code that: 1. Stores the previous state of anything that (possibly) needs to be undone. 2. Sets a sub to be run when the user selects undo. 3. Write that subroutine, which reverses the changes last made by your code. In this article ...
Thu, 09 Mar 2006 06:50:00 GMT

Interactivity on jkp-ads.com
I have recently added a database to my site. Now I am learning classic ASP and VBScript (I know, why not .NET?) to use this database and put some interactivity on my site. Take a look! Some articles now have a set of stars at their final page with which you can rate them.
Fri, 24 Feb 2006 19:10:00 GMT

Excel VBA: Registering a User Defined Function with Excel.
When one writes a User Defined Function in Excel VBA, this function appears in the function wizard under the category "Custom". It is possible to change the function category by changing the "macro properties" of the UDF. Unfortunately, VBA does not allow specifying descriptions for the UDFs arguments. One can do this using the ...
Fri, 17 Feb 2006 08:20:00 GMT

Excel utility: Watching a cell way off to the right.
When working with Excel worksheets with a lot of used columns, it would be easy if one could have a way to show the content of a column on the same row in a window. This new WatchOtherCell utility does just that.
Thu, 09 Feb 2006 14:20:00 GMT

Using Parameters With Web Queries
Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on the values in so called ...
Tue, 03 Jan 2006 20:00:00 GMT

Macro in Excel Stops After A Workbook.Open Command
Sometimes Excel VBA behaves unexpectedly. Here is an example: You are running code that is meant to open one or more files using the Workbooks.Open command. As soon as you hold down the shift key when this command is being processed, macro execution stops and your program is terminated entirely. This will even happen if you are ...
Fri, 11 Nov 2005 12:30:00 GMT

Formules voorzien van een foutcontrole
Het gebeurt regelmatig, dat ik een bereik met formules heb dat op zich goed werkt, maar dat een foutcontrole nodig heeft, bijvoorbeeld om delen door nul te voorkomen. Dit artikeltje toont wat VBA code om de formules in een reeks cellen te converteren zodat ze een foutcontrole krijgen.
Mon, 31 Oct 2005 12:30:00 GMT

Excel-macro's geschikt maken voor anderen.
Dit artikel is nu volledig in het Nederlands beschikbaar!!! Beschrijving: Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen ...
Tue, 25 Oct 2005 13:30:00 GMT

Beheersen wanneer een event wordt verwerkt of niet
Events zijn een krachtig hulpmiddel bij het programmeren met Excel. Events maken het mogelijk te reageren op acties van de gebruiker zoals het bewerken van een cel of het klikken van de knop Afdrukken. Wanneer een applicatie gebruik maakt van events, dan is het ook vaak nodig de controle te hebben over het feit of de code in het ...
Fri, 07 Oct 2005 17:50:00 GMT

Control When Events Are Handled
Events are a powerful aspect of Excel programming. They enable you to make your application respond to user actions such as entering data into cells or clicking the print button. If your application uses events, you will probably also need to be able to control whether or not an event executes its code or not (e.g. to avoid event ...
Wed, 14 Sep 2005 08:30:00 GMT

Excel-macro's geschikt maken voor anderen.
Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen van macro's, komen vervolgens tot de ontdekking dat de macro recorder ...
Tue, 23 Aug 2005 18:50:00 GMT

Wrapping Formulas In An Error Test
Oftentimes I have a range filled with formulas that as such work correctly, but need an error checking mechanism. For example to account for cells that are empty. This article shows some code to achieve that. But there is more. I plan to add functionality as we get along.
Tue, 19 Jul 2005 20:40:00 GMT

Range Names in Excel
In Excel you can give a range of cells a name. When you do that, you can use this name instead of the address to point to that range. In general it is easier to remember a name than a range address of the start and end of a range of cells. Using names has a couple of advantages: ranges are easier to find, formulas are simpler to ...
Wed, 6 Jul 2005 20:00:00 GMT

Bereiknamen in Excel
In Excel is het mogelijk een bereik van cellen een naam te geven. Wordt dat gedaan, dan kan voortaan deze naam gebruikt worden om naar dat bereik te verwijzen, in plaats van het adres. Over het algemeen is een naam van een bereik makkelijker te onthouden dan het adres van de begin- en eindcel van een bereik. Het gebruik van namen ...
Tue, 28 Jun 2005 09:40:00 GMT

Show less news