Web Changes

Last 20 changes to this site (in reverse chronological order, both Dutch and English updates are shown):

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 are called controls because they enable your user to control the content of your model. This article shows how to put controls to use in your model.
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 in staat stellen Excel te "besturen". Dit artikel laat zien hoe deze elementen gebruikt kunnen worden.
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 parameter cells.
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 some modifications to the class module, which I refined a little. The results are summarised in this article.
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 laat zien hoe het u kan helpen in uw dagelijks werk met Excel.
Tue, 28 Apr 2009 08:10:00 GMT