Home Article index Newsletter

Deze pagina in het NederlandsHome >

Downloads

Excel versions

These files should all work in all recent versions of Excel, unless stated otherwise.

Blocked files problem

If you open an add-in file but none of the buttons work, perhaps you are experiencing this issue: Excel: Add-ins do not load

Excel add-ins and workbooks

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 !

Name Manager

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

FlexFind

Flexfind 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

Autosafe.zip (Build 148, 22 March 2021, downloaded: 56.124 times)

New in Autosafe: bugfix for 64 bit Office.

Autosafe tries to overcome some limitations of the built-in Autorecover feature. This 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), Lithuanian and Hungarian.

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

Autosafe does not work on a Mac.

GoBack

GoBack.zip (8 Feb 2021, downloaded: 14.983 times) Version 1.0 build 012.

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.

Now updated with ribbon user interface.

Follow Cell Pointer

FollowCellPointer.zip (7 Dec 2016, downloaded: 27.731 times) Version 1.0 build 011.

A small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your formatting and has an option to preserve the undo stack.

Sheet Tools

SheetTools.zip (04 May 2015, downloaded: 7.399 times) Version 1.0 build 001.

This is the file that accompanies my article on how to build an Excel add-in

Table Tools

TableTools.zip (8 Feb 2021, downloaded: 5.251 times) Version 1.0 build 008.

This is a small utility to make your life with tables a little easier. See this article

Slicers

Slicers.zip (29 Aug 2019, downloaded: 1.744 times).

This download contains files accompanying this article: Synchronising Slicers

Compare Two Tables

Compare2Tables.zip (April 20, 2020, downloaded: 1.998 times) Version 1.0 build 009.

A tool which compares two tables. The tool produces three new tables. Two tables containing the records which are in table 1 and not in table 2 and vice versa and one which lists all records which have been modified. Adds a button to the Data tab of the Excel ribbon.

Spreadsheet Model Template

EUDA-template-EN.xlsm (8 Feb 2021, downloaded: 2.179 times)

EUDA-template-NL.xlsm (8 Feb 2021, downloaded: 1.298 times)

This template makes starting a new spreadsheet model easier as it already contains some functionality I think every model should have.

As discussed in this article

Validation dependent lists

DependentValidationUsingDA.xlsm (22 June 2020, downloaded: 1.023 keer)

This demonstrates how to create dependent validation lists using DA Excel.

Close All Workbooks And Quit

CloseAllWorkbooksAndQuitExcel.zip (01 Oct 2015, downloaded: 4.262 times) Version 1.0 build 001.

With the new MDI interface introduced with Excel 2013, closing all workbooks has become unnecessary difficult. This little addin adds a 'Quit Excel' button to your File menu that will close all open workbooks and quit Excel. It also features a Short-cut key: control+q

Header Footer

HeaderFooter.zip (24 August 2018, downloaded: 15.839 times) Version 1.0 build 007.

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.

Setup Utility

SetupUtility.zip (Updated May 5, 2008, downloaded: 17.999 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.

Update An Addin

UpdateAnAddin.xls (Updated February 19, 2007, downloaded: 37.980 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.

Show Table On Userform

ShowTableOnUserform.zip (14 May 2008, downloaded: 14.776 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.

Two Listbox Drag Drop

TwoListboxDragDrop.zip (June 10, 2020, downloaded: 896 times)

Demonstrates how to activate drag and drop between two listboxes on a Userform. See this article.

Fix Links to UDF

FixLinks2UDF.zip (02 June 2008, downloaded: 9.179 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.

Switching Office Channel

SwitchingOfficeChannel.zip (04 May 2020, downloaded: 426 times)

A set of four BAT files to aid in switching your Office 365 to a different Channel.

Query Manager

QueryManager.zip (Build 017, 23 September 2010, downloaded: 19.640 times)

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

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

2. Add parameters

3. Change the path to the data source

All in a single dialog.

Autosafe VBE

AutosafeVBE.zip (build 026, 6 Aug 2007, downloaded: 25.001 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!!

Non linear Least Squares

nonlinearls.zip (12 Apr 2012, downloaded: 23.784 times) Fit complex functions like y=exp(a.x).sin(x) + b to data using Least squares

Excel VBE Multiline Search

ExcelVBEMultilineSR.zip (Version 1.0, Build 004, 27 Nov 2008, downloaded: 11.062 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!

Copy VBA Project

CopyVBAProject.zip (Version 1.0, Build 011, 22 Jun 2016, downloaded: 13.138 times)

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B

USE AT OWN RISK!

Export VBA Project

ExportVBAProject.zip (Version 1.0, Build 005, 1 Sep 2015, downloaded: 8.482 times)

This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use this handy tool to compare differences in the exported files: ExamDiff

Github VBA Exporter

GithubVBAExporter.zip (Version 1.0, Build 010, Apr 28, 2021, downloaded: 269 times)

This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.

Performance Class

PerformanceClass.zip (Version 1.0, Build 001, 20 Aug 2014, downloaded: 5.910 times)

This example file demonstrates the use of a class module to measure performance of your VBA code. See A VBA performance class for an explanation.

Trusted Document Manager

TrustedDocumentManager.zip (Version 1.0, Build 001, 10 oct 2013, downloaded: 5.863 times)

This little tool enables you to manage your list of trusted documents. Currently, Excel only allows you to either leave the list intact, or delete the entire list. This means all of your currently trusted documents become untrusted again so you have to enable macro's on all of them once again. The tool allows you to remove just one file, remove an entire folder or even an entire drive. Also it offers the possibility to remove files which no longer exist from the list.

Only available for Excel 2010 and up!

Object Lister

Objectlister.zip (Version 1.0, Build 003, 1 October 2008, downloaded: 16.960 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.

Tree View

An All-VBA (MSforms) treeview control that makes the common controls treeview obsolete. Works in all Office versions as of Office 2000, including 64 bits and MAC office.

The Excel download contains most of the documentation (on the tabs of the workbook), so I recommend you to at least download the Excel version.

Download the treeview sample workbook (build 024, 20 May 2013, downloaded 41.244 times)

Download the treeview sample Word document (build 024, 20 May 2013, downloaded 13.115 times)

Download the treeview sample Access database (build 024, 20 May 2013, downloaded 33.490 times)

See the accompanying article: An MSForms (all VBA) treeview

Wheel of Fortune

A wheel of fortune, built entirely in Excel!

Excel wheel of fortune (29 September 2016, downloaded 7.913 times)

See the accompanying article: Creating a Wheel Of Fortune with Excel

VBA driven circular references

VBADrivenCircularReferences.zip (11 February 2015, downloaded 4.139 times)

This file demonstrates the use of VBA to control circular reference calculations. See: Working with Circular references in Excel, Properly setting up circular references

AutoChrt

AutoChrt.zip (2 March 2015, downloaded: 24.710 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.

Simple Inventory System

SimpleInventorySystem.zip (11 Oct 2016, downloaded: 11.791 times)

A simple inventory system built in Excel using simple formulas.

Moving Checkbox

MovingCheckbox.xlsm (29 Feb 2016, downloaded: 11.836 times)

A small demo file which contains a column in which a checkbox is automatically displayed tied to the underlying cell.

Chart An Equation

ChartAnEquation.zip (May 1, 2005, downloaded: 15.564 times)

Demonstrates a method to chart a mathematical equation using just defined names.
See this article for an explanation.

Control Handler

ControlHandler.zip (17 June 2005, downloaded: 12.721 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.

Control Lister

ControlLister.zip (10-7-2014, downloaded: 8.066 times)

Tool that lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table. Note: does not handle userforms with multipage controls very well!

Catch Paste Demo

CatchPasteDemo.zip (17 Dec 2007, downloaded: 12.610 times)

Demonstrates how to intercept paste operations in a workbook to prevent users from wrecking your validation. The download contains two workbooks; one for Excel 2003 and earlier, the other for Excel 2007 and 2010. See this article for an explanation.

Undo Handler

UndoHandler.zip (8 March 2006, downloaded: 16.197 times)

Demonstrates a method to enable the user to undo changes made by your VBA code. See this article for an explanation.

Watch Other Cell

WatchOtherCell.zip (18 September 2012, downloaded: 13.207 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.

Get A Range

GetARange.zip (4 May 2006, downloaded: 16.895 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.

Edit Open XML

EditOpenXML.zip (5 September 2011, downloaded: 15.390 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 .

Modeless Form On Top

ModelessformOnTop.zip (26 November 2012, downloaded: 7.935 times)

Excel 2013 now has a SDI as opposed to the MDI previous Excel versions have. This file demonstrates how to keep a modeless userform on top of the Excel 2013 window. Find a full description here .

Arg2Name

Arg2Name.zip (8 February 2001, downloaded: 20.817 times)

This workbook demonstrates a trick to pass (range) arguments to defined name formula's. See the Excel names page.

Command Bar IDs

xlMenuFunDict.zip (29 Jan 2003, downloaded: 27.190 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 358 in total (Show All Comments):

 


Comment by: Greg (6-5-2020 13:05:00) deeplink to this comment

Thanks for Follow The Cell!

I'm using it with the UNDO option - is there a way to style the color? Change the grey from the default?

Thanks, Greg


Comment by: Jan Karel Pieterse (6-5-2020 13:37:00) deeplink to this comment

Hi Greg,

I'm afraid not, all it does is select an entire row and an entire column so you get the default color Excel uses as a background for a selected cell.


Comment by: Michael (18-12-2020 01:43:00) deeplink to this comment

Hi Jan Karel!

Love your Autosafe Add-in! Been using it for like 15 years!

I've come across an error that has destroyed multiple workbooks, rendering them with critical errors that are not repairable or saveable after Autosafe fails. Something in the SaveAsCopy portion.

It just started happening today and I've disabled/re-enabled, updated it (it did need an update), restarted my PC, etc. The second the first AutoSafe timer goes off, Excel is biffed.

Any ideas? I'll just disable it for now.

Thank you so much for your contributions to the community. They are second to none!


Comment by: Jan Karel Pieterse (18-12-2020 15:48:00) deeplink to this comment

Hi Michael,

Odd, I do not see that problem. Is there any chance you could share one of those wrecked workbooks with me? Perhaps even a "before" and an "After" version?


Comment by: Michael (22-12-2020 19:58:00) deeplink to this comment

Apologies for the delay in responding. I didn't receive an alert in my email that you did!

The workbook and Excel (365) in question is on a client machine and the workbook itself is highly sensitive. It also contains the Full Works in terms of Power Query, Data Model, Power Pivot, etc.

Now that I have some breathing room, let me try to re-enable the add-in on that machine and see if it works for other workbooks and if the failure is workbook-specific. I never thought to do that last week when I was buried in it and needing to meet a deadline.

If I do verify an error, shall I send you screenshots or whatever I can to the jkp-ads webmaster address?


Comment by: Jan Karel Pieterse (23-12-2020 11:38:00) deeplink to this comment

Hi Michael,

Unfortunately, my website does not have the possibility to notify you for new replies as all comments are "independent". Your only notification is that your message was posted.


Comment by: Dinesh Gaikwad (6-2-2021 08:02:00) deeplink to this comment

Please explain non linear regression by least suqre method,thanks.


Comment by: Jan Karel Pieterse (6-2-2021 16:36:00) deeplink to this comment

Hi Dinesh,

Please see: https://jkp-ads.com/Articles/leastsquares.asp


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.