Subscribe in a readerWeb Changes
Last 20 changes to this site (in reverse chronological order, both Dutch and English updates are shown):
| 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 the same text import settings over and over? How do you import the data from those files into the same worksheet each time, without having to re-define the import settings over and over again? I'll tell you. 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 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 |
