Downloads

Acknowledgements

Most files on this page are also available at Stephen Bullen's website.

Excel versions

These files should all work in Excel 97, 2000, XP, 2003 and 2007, unless stated otherwise. For some downloads a dedicated version for Excel 2007 is available.

Donations

The files

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!

Other downloads

The Name Manager An excellent utility to manage defined names in your workbooks.

Flexfind (Added an Excel 2007 version on Dec 19 2006) eases searching and replacing throughout an entire workbook. Also enables you to search and replace strings in objects such as headers and footers, chart titles, buttons and many, many more.

Autosafe.zip (Build 123 , 25 Mar 2009, 891k, Downloaded: 16004 times)
New in Autosafe: Autosafe now checks the computer's idle time and stays quiet as long as you have used the system within the last 30 seconds.
Version 3.5 of Autosafe enables use in environments with long paths/filenames. The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file on disk. This is not very convenient if you planned to leave the master file intact and save the changed workbook using a different filename. It also does nothing to simplify recovery of unsaved/changed documents after a system crash. This Autosafe utility creates copies of open workbooks at regular intervals in a separate (user-selectable) directory. It does not overwrite the master file(s), that is up to the user to do, using normal methods. As soon as a workbook is closed the backup copy is deleted from the backup directory. If an abnormal termination of Excel occurs, the backup copies remain on disk, and Autosafe finds them the next time Excel is started and presents recovery options to the user.
Autosafe comes with an autoupdate function which checks for updates every week. Includes the following languages: English, Dansk, Deutsch, Español, Français, Indonesia, Italiano, Nederlands, Norsk, Hrvatski, Slovenščina, Korean, Русский (Russian).

The previous version is still available: Autosafe34.zip (13 January 2003, 228k, Downloaded: 1570 times) Note that this one shows a nag screen on networked computers.

GoBack.zip (8 February 2005, Downloaded: 4494 times) Version 1.0 build 003.

Sometimes one has to edit a large workbook, with many worksheets. This tiny utility keeps a record of the ranges you have visited and gives you the opportunity to return to previous selections using two hot keys: control-alt-p to go to a previous selection and control-alt-n to go to the next. It also creates a toolbar with a dropdown to select a previous selection and to disable/enable the utility.

HeaderFooter.zip (28 January 2008, Downloaded: 2094 times) Version 1.0 build 006.

Managing headers and footers in Excel can be a drag. This little tool helps you to change headers and footers in your files easily by means of a toolbar that shows dropdown/edit boxes in which you can type the header/footer codes directly or select them from the list of currently present header/footer codes in your file.

SetupUtility.zip (Updated May 5, 2008, Downloaded: 6363 times)

If you have created a nice add-in (see this article how to do that), 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: http://tinyurl.co.uk/zde9).

UpdateAnAddin.xls (Updated February 19, 2007, Downloaded: 4626 times)

If you have created a nice add-in (see this article how to do that), an updating mechanism is an easy way to ensure your users get any bugfixes you did automatically . This download demonstrates how you can implement this functionality in your addin.

ShowTableOnUserform.zip (14 May 2008, downloaded: 1483 times)

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 far from easy... See this article on how it works.

FixLinks2UDF.zip (02 June 2008, Downloaded: 734 times)

A demo file that handles #Name! errors for workbooks that use UDFs that reside in an add-in. See this article on how that works.

QueryManager.zip (Beta!, Downloaded: 5876 times)

This utility has been developed together with Dick Kusleika. It eases the editing of queries. One can:

1. Edit the SQL string and the connect string of queries

2. Add parameters

3. Change the path to the data source

All in a single dialog.

AutosafeVBE.zip (build 026, 6 Aug 2007, 260k, Downloaded: 7543 times) This utility makes backup copies of VBA components to a user-defined directory. It keeps a user selectable number of copies of each component. It thus keeps a number of generations of your code as your work progresses, enabling you to return to a previous copy when things go wrong. Because it just exports the VBA components, it is unobtrusive because this process is relatively fast compared to saving your workbook or document. Excel and Word version included!!

ExcelVBEMultilineSR.zip (Version 1.0, Build 004, 27 Nov 2008, 634k, Downloaded: 2062 times) This utility enables you to do Search and Replace operations in the Visual Basic Editor of Excel. What is special about this tool is that you can search for multiple lines of code and replace with multiple lines of code.
WARNING: ALPHA VERSION, USE AT OWN RISK!

CopyVBAProject.zip (Version 1.0, Build 007, 05 Oct 2007, 56k, Downloaded: 2146 times) This utility enables you to copy the components from the VBAProject of workbook A to Workbook B
Build 004: Existing modules are removed before copying.
USE AT OWN RISK!

Objectlister.zip (Version 1.0, Build 002, 12 May 2007, 56k, Downloaded: 3196 times) Lists objects, properties and methods of the selected object and enables you to quickly build code that uses many properties of an object. See the ObjectLister page for more information.

AutoChrt.zip (10 November 2000, 7k, Downloaded: 9707 times)
Automates the process of creating graphs from database-like datasets, where you need to chart various columns against each other in x-y scatter charts to determine relationships between them. It consists of a sheet where to copy the data into and a sheet that holds the chart and some spinner-buttons to control which data are charted.

ChartAnEquation.zip (May 1, 2005, 5K, Downloaded: 4603 times)
Demonstrates a method to chart a mathematical equation using just defined names.
See this article for an explanation.

ControlHandler.zip (17 June 2005, 26k, Downloaded: 3954 times)
Demonstrates a method to handle the events for multiple controls on a worksheet using a single class module. See this article for an explanation.

CatchPasteDemo.zip (17 Dec 2007, 21k, Downloaded: 1362 times)
Demonstrates how to intercept paste operations in a workbook to prevent users from wrecking your validation. See this article for an explanation.

UndoHandler.zip (8 March 2006, 24k, Downloaded: 3639 times)
Demonstrates a method to enable the user to undo changes made by your VBA code. See this article for an explanation.

WatchOtherCell.zip (9 February 2006, 25k, Downloaded: 3809 times)
This workbook simplifies looking at data in a sheet with a lot of columns. It shows the value of a cell on the same row in a column one can enter in a textbox. This way you can scroll all over the sheet and always (e.g.) have the value of a cell in column BE in view. Start the watcher by opening the file and using its entry in the Tools menu.

GetARange.zip (4 May 2006, 26k, Downloaded: 5058 times)
This workbook demonstrates a bug in the VBA Application.InputBox function as described here. The workbook also contains a userform and sample code to work around that bug.

EditOpenXML.zip (6 May 2009, 26k, Downloaded: 223 times)
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 this demo file. Find a full description here.

Arg2Name.zip (8 February 2001, 10k, Downloaded: 7141 times)
This workbook demonstrates a trick to pass (range) arguments to defined name formula's. As published in David Hagers' EEE #9, available from John Walkenbach's web site. See the Excel names page.

xlMenuFunDict.zip (29 Jan 2003, 810k, Downloaded: 8166 times)
International versions of Office have the menu system in their local language. Also the Excel worksheet functions are (mostly) listed in local language. This complicates communication with the users with such a version. To aid in this process a utility has been devised that creates and shows a translation list of the Excel built-in command bars and controls and the Excel worksheet functions. This workbook can also list command bars of other Office software packages. It thus enables the international user who is using a different language version of Excel to quickly find translations for sequences of menu commands and function names.

Comments

Showing last 8 comments of 72 in total (Show All Comments):

Comment by: Brian (4/21/2009 4:02:34 PM)

Have you found anything out about LJ's problem? I'm having the same issue.

Comment by: Jan Karel Pieterse (4/21/2009 9:22:51 PM)

Hi Brian,

No, LJ hasn't responded. You can send the file if you like though.

Comment by: Abdul Qayyum (6/12/2009 2:57:18 AM)

Sir

I want to an attendance reqister which sandwitch the rest day if the absent occur before and after the rest day means if a occure before and after r then the r count as a
please help me in this mater i will be thank ful to u

Thanks

Abdul Qayyum

Comment by: Jan Karel Pieterse (6/12/2009 4:55:35 AM)

Hi Abdul,

Of course I can develop something for you commercially. Please send me an email using the email address at the bottom of this page.

Comment by: Jim (6/17/2009 7:48:12 PM)

I love Autosafe - it makes file recovery so much easier :-). But it has one nasty side-effect: whenever it runs, Excel's undo list clears. I count on being able to undo actions, but now never know when I'll be unable to do this. Is there any workaround to avoid this behavior?

Thanks!

-jim.

Comment by: Jan Karel Pieterse (6/17/2009 9:24:45 PM)

Hi Jim,

I know, that is the only real drawback of Autosafe (in fact, of anything that does a save in Excel): it zaps your undo list.
Luckily, as of Excel 2007 the undo list is no longer affected by a save.

Comment by: Jim (6/17/2009 11:19:32 PM)

Hmm, I think something else is going on. I'm running Excel 2007 SP2, and indeed, if I manually save a file, the Undo list stays intact. But the moment that Autosafe backs up my files, my Undo lists clear. Any other ideas?

Thanks!

Comment by: Jan Karel Pieterse (6/18/2009 12:11:32 AM)

Hi Jim,

Odd indeed, seems the save through the UI does not behave the same as save through VBA.
On my system (2007 sp2) the last undo action is is retained however, so it is slightly better than 2003 and before used to be.