Subscribe in a readerWeb Changes
Last 20 changes to this site (in reverse chronological order, both Dutch and English updates are shown):
| 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 |
| 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 |
