Home

Excel spreadsheet expertise inculding VBA programming

Access database development

Excel downloads - free examples of useful programmes and games

Training - one to one tuition tailored to your business

A brief history of projects and customers

Links to useful web sites

Free Downloads
Free Downloads

Glynn Consulting Ltd
Registered in England No. 5246276


Tel 01279 420066
Mobile 07704 863596

Email robin@glynnconsulting.co.uk

Excel Downloads - Utilites and Games...

Here you can find some really useful Excel utilities, and (when the boss isn't looking) a bunch of fun games. All of these programs are open source (no passwords) and will run happily on any version of Excel from Office 97 to Office 365. Because you can see all the code, and the code is commented throughout, they also serve as a great training aid for developing your own projects. The list will continue to grow, so pop back from time to time and see what's new.

The utilities were written to deal with real world business problems and have proved their worth time and time again. If you require a solution for your business then please contact us to find out what we can do for you.

Legal Notice

These Excel examples are made available on an 'as-is' basis. All warranties, representations or guarantees of any kind (whether express, implied or statutory) including, without limitation, warranties of merchantability, non-infringement, or fitness for a particular purpose, are specifically disclaimed. IN NO EVENT SHALL GLYNN CONSULTING LTD BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY. Having said all that (because we have to) we have never encountered any problems.



Macro Virus Protection

In Excel, you may have to adjust the macro security level low enough to allow the programs to run. The location to change macro security settings depends on which version of Excel you are using…

For Excel 2007+

File menu or Office Button (2007) > Excel Options > Trust Center > Trust Center Settings button > Macro Settings

For Excel 2003

> Tools > Options > Security > Macro Security must be set to Medium or Low

For earlier versions of Excel

The settings will be somewhere under Tools > Options

Note - for some versions of Excel for Mac, macros written in VBA are not supported at all. Microsoft finally recognised this is financial suicide and reinstated macro support in version 2011



Utilities

RenameFiles - Amazingly Windows Explorer has no facility to rename multiple files. Even good old DOS only gives is wildcard filename changes. This Excel utility allows you to list all files in a chosen directory and make global changes to the names and/or extensions. You can use find and replace, or use formulas to manipulate text (the utility provides you with some ready made formulas you can use). As this will rename large batches of files, be careful!!! Use common sense - like working on copies of files.
View Screenshot
Download File

MailShot - This is a highly flexible yet very simple way of sending personalised letters to a list of customers. It will print any given range of customers from your list, and also print address onto envelopes. The default page size is set to 'A4' for letters and 'DL' for envelopes but can be simply changed to any other size.
View Screenshot Download File

ListMaker - This can save you hours of laborious copying and pasting. If you have many spreadsheets set up the same way (like one spreadsheet per department), you can create a consolidated report by listing which cells you want to extract, clicking the 'Create a list of files' button and then 'Produce Report'.
View Screenshot Download File

AlignTables - When you are trying to compare 2 similar tables and find the differences, this utility brings the tables in line with each other. It's amazing how often this type of problem crops up and this can save a lot of manual effort or messing around with lookup formulas.
View Screenshot Download File

PhasingFunction - This is an example of a custom function that can greatly speed up forecasting. Simply change the value, start period, or duration and see all of your figures change. Phasing can be spread linearly or over any profile you can create. This can be incorporated into automated forecast systems.
View Screenshot Download file

ModifyWorkbooksUtility - If you have a large number of spreadsheets set up the same way and you need to change them all, then this will change them all for you. Just record a macro (or write one) that changes one spreadsheet, stop recording, paste in the code, list the files and you're done.
View Screenshot Download File

WorksheetAnalyser - If you have a workbook with a large number of sheets with the same layout, then this utility can create a report extracting data from each sheet as a new line.
View Screenshot Download File




Games

Crossroad Tiles - An original puzzle game that is quite a bit harder than you might think. There are 3 levels of difficulty available, but even 'easy' can be quite tricky.
Please note, this requires Excel 2007 or later.
View Screenshot Download File

Nonogram - This plays a bit like Sudoku, except you fill in squares to draw a picture based on the numbers outside the grid. It's a fun game and includes 35 built in levels and a level designer so you can create your own.
Please note, this requires Excel 2007 or later.
View Screenshot Download File

CellSweeper - This is a version of the windows Minesweeper game. The controls are slightly different but are very intuitive, especially the 'double-click' to clear large areas in one go.
View Screenshot Download File

Random Insult Generator - This was created to see what fun could be had from Excel could do without any macro programming at all. Using standard Excel formulas and a fully customisable list this spreadsheet can generate over 2 million insults without using a single swear word. You can keep adding to the list to create even more combinations, but please, keep it clean!
View Screenshot Download File

Robin's Square - This is a completely original puzzle game with 2 difficulty settings, 'easy' (which is hard!) and 'hard' which is diabolical! There is a built in solver to prove that it can be done, but it's quite a challenge.
View Screenshot Download File

Slot Machine - This slot machine includes holds, nudges and a high/low gamble. It's also quite generous unlike the real thing!
View Screenshot Download File