Start | MVPs 

        MVP Weblogs

door: Jan Karel Pieterse
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
comments 6/25/2015 8:15:00 AM

door: Jan Karel Pieterse
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.
comments 6/25/2015 8:15:00 AM

door: Jan Karel Pieterse
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!
comments 6/22/2015 5:45:00 PM

door: Jan Karel Pieterse
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.
comments 6/8/2015 5:40:00 PM

door: Jan Karel Pieterse
RefTreeAnalyser 2.0 has just been updated. I have added support for hotkeys using the Alt key.
comments 5/6/2015 7:30:00 PM

door: Jan Karel Pieterse
Today I posted an entirely new article. It describes all the steps needed to create a basic Excel add-in.
comments 5/4/2015 4:10:00 PM

door: Jan Karel Pieterse
Today I posted a link to one of the most comprehensive sets of Excel productivity tools I have ever seen: Andrew's Excel Utilities
comments 4/7/2015 10:30:00 AM

door: Jan Karel Pieterse
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. As of March 27st, 2015 we offer a € 200 last-minute discount per attendee for both days and € 100 for one day! Register now at http://topexcelclass.com/index.php/amsterdam-excel-summit/registration/ and meet us on April 13th and 14th in Amsterdam.
comments 3/27/2015 9:20:00 AM


We’ve released LLBLGen Pro  v5.0 CTP 1! It’s a Community Technical Preview (CTP) of the upcoming v5.0 which is in development since fall 2014. The CTP is open for all v4.x customers (it’s in the customer area, in the v4.2, betas section) and comes with a time-limited license which expires on June 1st, 2015. As this isn’t a full beta, (much) more features are added before beta hits.

Below I’d like to show some of the new features in action. Click the screenshots for a bigger version.

New, skinnable UI

A new UI was long overdue. The current (v4.2) version still uses VS.NET 2008 like toolbars/controls and it looks just… dated. So, we ported the complete UI to DevExpress controls (still winforms though) as some of our controls were already based on those. The screenshots below show the default VS.NET 2013 white theme.

New Relational Model Data Sync System

In short: the Sync system. Sync replaces both database first related actions like refresh catalog and model first related actions like auto-map and adjust relational model data. It allows a sync source to be set for a schema which controls the source from where table related relational model data is obtained from: the database or the entity model. Stored procedures/views/tvfs are always obtained from the database. Everything is managed from a single tab, the Sync Relational Model Data tab, which is opened by clicking the sync button on the toolbar or menu item in the project menu.


A big benefit from the new system is that it will function even when the project contains errors: it's no longer necessary to correct project elements before a refresh. It also doesn't adjust relational model data on database synced schemas, so it's no longer required to export DDL SQL before code generation because the validation adjusted some fields based on a change.

Revamped Home tab

The Home tab now shows active tiles the user can click to navigate through one of the scenarios (database first / model first and new / existing project). Which tiles are shown depends on what the user did last and the state of the designer.


It's an easy way to get started with the designer and replaces the webpage based home tab which was static.

It acts like a wizard in disguise: you can do the basic tasks right from the home tab, by clicking tiles. Here I’ve opened a Database first project and the state of the designer now shows different tiles with different actions.


Search in Project Explorer / Catalog Explorer

Directly available in the Project Explorer and Catalog Explorer are the search boxes: type in any string and the nodes matching the string are kept, all other nodes are filtered out. This allows finding elements with ease. Removing the search replaces the tree as it was before the search. In the below screenshot I’ve searched for ‘Sales’ in both the project explorer and the catalog explorer. It shows all nodes matching the string specified, including parent nodes (to give context) and hiding other nodes. The more advanced, LINQ query based search is still available in the designer, but this dedicated search on the two explorer panes is easier to use and requires no extra forms to navigate.


Real Time Validation

The designer got a real time system to schedule and run tasks at will through several dedicated dispatch queues. This greatly helps offload work from the UI thread while not having to mess with multi-threading as it utilizes the .NET 4.5 Task Parallel Library. Configuring work is as easy as defining an event, a handler and which dispatch queue to run the handler call and the system takes care of the rest, including overflow protection (so only a limited number of calls are allowed per interval).

The real-time validation in action:


So these are the highlights of this CTP (there are many tiny improvements under the hood too). We’ve much more in store for v5.0, so stay tuned Smile

comments 3/17/2015 4:20:11 PM

door: Jan Karel Pieterse
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 bird discount period with an additional week. So register before March 1st 2015 and receive the 50 Euro discount!
comments 2/23/2015 3:40:00 PM

door: Jan Karel Pieterse
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!
comments 2/11/2015 10:30:00 AM

door: Jan Karel Pieterse
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, ...
comments 2/10/2015 6:20:00 PM

door: Jan Karel Pieterse
Name Manager for Excel has been updated. Improved renaming rangenames in VBA code.
comments 2/10/2015 6:20:00 PM


I caved. For years I’ve denied requests from customers to publish the LLBLGen Pro runtime framework assemblies on nuget, for the reason that if we had to introduce an emergency fix in the runtimes which also required template changes, people with dependencies on the nuget packages would have a problem. While this might be true in theory, in practice it’s so uncommon that this will happen, it more and more turned into an excuse.

Add to that that customers started publishing the runtimes themselves on nuget, it was time to bite the bullet and publish the runtimes ourselves, officially. So we did. At the same time we published the interceptor assemblies of ORM Profiler on nuget.

The URLs

For LLBLGen Pro:


For ORM Profiler:


Who are these assemblies for?

The assemblies are for customers who want to stay up to date with the latest runtimes. Every time we publish a new build, the runtimes and interceptor dlls are automatically updated with the latest build. We never introduce breaking changes in released assemblies, so they’re safe to use in code and update to the latest version.

How are they versioned?

The LLBLGen Pro Runtime Framework assemblies are versioned as: 4.2.yyyymmdd, where yyymmdd is the build-date. The ORM Profiler interceptors are versioned as: 1.5.yyyymmdd.

What’s in the packages?

The DQE packages come with a single DLL, the DQE dll, and have a dependency on the ORMSupportClasses package. The ORMSupportClasses package contains both the .NET 3.5 build and the .NET 4.5 build with async support: if your project targets .NET 4.5 you automatically will reference the .NET 4.5 build with async support.

The Interceptor packages contain the interceptor dll and support dlls which don’t need their separate package. The Entity Framework interceptor has a dependency on Entity Framework 6.

Do the DQE packages depend on ADO.NET provider packages?

No, as all DQEs work with the DbProviderFactory system and don’t need the using project to reference an ADO.NET provider reference. The ADO.NET provider has to be present on the system, but as the provider assembly doesn’t need to be referenced by the VS.NET project the DQE package doesn’t need a direct dependency on the related ADO.NET provider package as that would mean the ADO.NET provider dll would be directly referenced after the DQE package has been installed.

Hope this helps the customers out who have asked us for so long for this feature Smile

comments 2/10/2015 5:33:58 PM

door: Jan Karel Pieterse
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!
comments 1/22/2015 11:15:00 AM