Windows  |  Free Downloads

 

 

 

Free Downloads for Microsoft Office

Please report any broken links immediately so we may keep this resource up to date!

If you would like your download listed here, or even uploaded here for download, forward it to downloads@officearticles.com and we'll be happy to upload it and list it for you. Please include how you'd like to be recognized for your contribution.

You can get Microsoft's templates at Microsoft's Office site. Once there, just click on templates and do a search.

Check our own downloads folder; we are constantly adding new things, some of which relate to articles found here on our site. You can see our downloads at www.officearticles.com/downloads. Our free downloadable files and templates include:

#

App

Name of Download

Description

Website/Link

1

Excel

Climate Data Workbook

An interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.

J-Walk.com

2

Excel

Gradient Contour Chart Add-In

An add-in that generates an alternative to Excel's contour chart. Charts produced by this add-in are not dynamic.

J-Walk.com

3

Excel

J-Walk Chart Tools

A collection of chart-related utilities.

J-Walk.com

4

Excel

J-Walk Enhanced Data Form Add-In

Version 2.0. An alternative to Excel's Data * Form command. Lots of enhancements, and the VBA source code is available (for a small fee) so you can customize it.

J-Walk.com

5

Excel

Animated Hypocycloid Charts

An Excel workbook that generates an infinite number of dazzling animated charts. You will be impressed.

J-Walk.com

6

Excel

Power Utility Pak v6

A collection of Excel utilities, functions, and enhanced shortcut menus.

J-Walk.com

7

Excel

Dice Roller

An Excel workbook that simulates rolling two dice.

J-Walk.com

8

Excel

Toolbar Calculator

An Excel add-in that creates a toolbar that functions as a simple calculator.

J-Walk.com

9

Excel

Clock Chart

An Excel workbook that contains an XY chart that displays a working analog clock. It uses a VBA macro to update the chart every second.

J-Walk.com

10

Excel

Employee Time Sheet

Easy-to-use time sheet for tracking daily hours worked.

J-Walk.com

11

Excel

ActiveX Control Demo

Demonstrates the use of ActiveX controls on a worksheet

J-Walk.com

12

Excel

J-Walk Cell Math Add-In

An add-in that enables you to perform any mathematical operation on cells without using formulas. An enhanced version of this utility is available in PUP v6.

J-Walk.com

13

Excel

Children's Multiplication Exercises

Assists in learning multiplication tables. Contributed by Jim Hubbard. Instructive for children and adults who are learning VBA.

J-Walk.com

14

Excel

AddPath Add-in

An add-in that enables you to print a workbook's full path in a header or footer.

J-Walk.com

15

Excel

Extended Date Functions

An add-in that provides a set of worksheet functions that enable you to work with dates prior to the year 1900 -- something that's not normally possible. An enhanced version of this utility is available in PUP v6.

J-Walk.com

16

Excel

J-Walk Date Report Add-In

An add-in that generates a useful report that describes all date cells in a worksheet. This may help you identify potential Year-2000 problems. An enhanced version of this utility is available in PUP v6.

J-Walk.com

17

Excel

J-Walk Select by Format Add-In

An add-in that enables you to select cells based on formatting. For example, you can easily select all cells that contain a specific number format and are red. An enhanced version of this utility is available in PUP v6.

J-Walk.com

18

Excel

Keno for Excel 97

A worksheet that simulates a Keno game. Just like the casinos - except you won't lose any money with this version.

J-Walk.com

19

Excel

J-Walk Conditional Row Delete

An add-in that makes it easy to delete rows based on the values in a specified column.

J-Walk.com

20

Excel

Timeline Chart

Demonstrates how to create an attractive "time line" (Gantt) chart in Excel.

J-Walk.com

21

Excel

Name Lister Add-In

An add-in that displays a list of names in a workbook by category (all names, workbook level names, sheet level names, hidden names, linked names, and "bad" names). An enhanced version of this utility is available in PUP v6.

J-Walk.com

22

Excel

Superscript / Subscript Formatting Add-In

An add-in that enables you to add superscript or subscript formatting to characters within a cell. An enhanced version of this utility is available in PUP v6.

J-Walk.com

23

Excel

Tony Gwynn's Hit Database

An Excel database with information about Tony Gwynn's first 3,000 hits. Use the pivot table to summarize the data in various ways. (Tony Gwynn is a baseball player on the San Diego Padres)

J-Walk.com

24

Excel

Menu Shenanigans

Makes a great April Fool's prank for an office-mate (preferably one with a sense of humor). VBA macros reverse the text in all of Excel's worksheet menus. The hot keys remain intact, so the menus can still be accessed using familiar keystrokes.

J-Walk.com

25

Excel

Appointment Calendar Maker

A workbook that lets you generate and print daily appointment calendar pages.

J-Walk.com

26

Excel

Guitar Scales and Modes

This workbook features a graphic depiction of a guitar fretboard, and displays the fret locations for the notes in any scale or mode, in any key you choose.

J-Walk.com

27

Excel

Excel Doodle Pad

Etch-a-Sketch with a new twist.This workbook displays a doodle pad that lets you create attractive symmetrical drawings using the arrow keys on your keyboard.

J-Walk.com

28

Excel

Array Calendar

Demonstrates how to create a calendar for any month using a single (complex) array formula.

J-Walk.com

29

Excel

Another Gantt Chart

This one was featured in John Walkenbach's PC World column.

J-Walk.com

30

Excel

Hangman Game

The classic word-guessing game, programmed in VBA - complete with cheesy hand-drawn graphics. Includes many words, and you can even add your own. An enhanced version of this utility is available in PUP v6.

J-Walk.com

31

Excel

Custom Number Format Examples

This workbook contains several examples of useful custom number formats.

J-Walk.com

32

Excel

MP3 File Lister

A macro-driven application that creates an attractive listing of MP3 music files.

J-Walk.com

33

Excel

A Class Module to Manipulate a Chart Series

A useful class module that makes it easy to work with the data used by a chart.

J-Walk.com

34

Excel

Soundex Demo

Demonstrates a technique that lets you search for a text based on its sound.

J-Walk.com

35

Excel

GetOption Function

Demonstrates a useful function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly.

J-Walk.com

36

Excel

Control the LED Display in the StatusBar

Originally developed by David Wiseman. It consists of VBA code that lets you control the "LED" display in Excel's status bar. I've always thought that this display was off limits, but David proved otherwise with some incredible programming. Very impressive! Thanks to David for letting me share this file with the world, and thanks to Jim Rech for modifying it so it works with Excel 2000.

This updated version is in the form of a class module (expertly programmed by Ole P. Erlandsen).

J-Walk.com

37

Excel

UserForm Hyperlink Demo

Demonstrates how to add hyperlinks to a UserForm Click

J-Walk.com

38

Excel

J-Walk FaceID Identifier Add-In

Makes it very easy to determine the FaceID value for a CommandBar image.

J-Walk.com

39

Excel

Charts in a UserForm

Demonstrates how to display one or more charts in an Excel 97 UserForm.

J-Walk.com

40

Excel

Menu Maker

A technique that makes it very easy to create a custom menu for an Excel 97 (or later) workbook or add-in. VBA programming not required!

J-Walk.com

41

Excel

Displaying Online Help

A technique that makes it easy to display help topics in a UserForm.

J-Walk.com

42

Excel

A Color Picker Dialog Box

Demonstrates a custom VBA function that displays a UserForm that lets the user select a color. Uses a class module.

J-Walk.com

43

Excel

Filling a ListBox With Unique Items

A clever technique to fill a ListBox with non-duplicated items in a list.

J-Walk.com

44

Excel

Handle Multiple UserForm Buttons With One Procedure

With an Excel 97/2000 UserForm, each control on the form has its own unique Click event, so you can't have several buttons that call the same Sub procedure. This workbook demonstrates a way around this limitation by using a class module.

J-Walk.com

45

Excel

ImageMap Demo

Demonstrates how to create a clickable image map for navigation within a workbook.

J-Walk.com

46

Excel

Animated Shapes

Demonstrates how to use VBA to generate some interesting animations using shapes and charts.

J-Walk.com

47

Excel

Progress Indicator

Demonstrates how to create a graphic progress indicator in a UserForm.

J-Walk.com

48

Excel

Dialog-To-UserForm Wizard

A handy utility that converts Excel 5/95 dialog sheets to Excel 97/2000 UserForms.

J-Walk.com

49

Excel

Generate Permutations

Uses a recursive procedure to generate all possible permutations of a string.

J-Walk.com

50

Excel

Copy Multiple Selection

A VBA macro that lets you copy and paste a multiple range selection -- something that's normally impossible.

J-Walk.com

51

Excel

Button Faces

Contains nearly 200 custom toolbar button faces that you can copy. These are not Excel 97/2000 CommandBar images. For Excel 5/95.

J-Walk.com

52

Excel

Range Selection Demonstration

Contains 15 VBA routines that demonstrate how to make various types of range selections. When you open the workbook, a new menu appears that lets you try out the various routines.

J-Walk.com

53

Excel

Multiple: Excel Utilities

Alert The best way to display diagnostic messages to users and developers. Overcomes the limitations of MsgBox, Debug.Print, and Application.Statusbar. Recommended for intermediate and advanced developers.

AltKeyList Creates a list of the ALT key menu accelerator keys (8 KB).

AppEvent Illustrates the use of Application level events. (10 KB)

Arr2Col Converts an NxM array to a single column or row. (19 KB)

Calendar A Calendar workbook. Allows you to have special days (birthdays, holidays, etc) automatically highlighted. (36 KB) NOTE: This file requires that both the Analysis Tool Pack and the Analysis Tool Pack VBA add-in libraries be loaded. Otherwise, you'll get run time errors.

Case Convert This add-in will allow you to perform a variety of text conversions (UPPER CASE, lower case, Title Case, Sentence case, etc) on a range of cells. Install the Add-In, and then choose Text Convert from the Excel Tools menu.

Cell View This add-in allows you to see the characters and their codes in a cell. This makes it easy to find unprintable characters such as tabs that don't display but may affect formulas.

Clock This workbook shows how to create and manipulate Shape objects on a worksheet to create an analog clock that ticks every second. (17 KB)

Compare This Add-In utility allows you to compare the contents of two workbooks. This was written by Myrna Larson and Bill Manville.

DistributedDates A file illustrating the formulas on the Distributed Dates page. (10KB) NOTE: This file requires the Analysis Tool Pack

DynaRange Using defined names to refer to dynamic ranges. (6 KB)

EventSeq Demonstrates the sequence of all Excel97 events. (14 KB)

FirstLast Extracting first and last names from full names. (6 KB)

FormPosition Excel typically displays forms in the center of the screen. This is usually fine for data entry and dialog forms. However, in many cases it is desirable to display a form in relation to a specific cell. This is not a simple a task as it seems because the top and left coordinates of a UserForm based on the same coordinate system as the Top and Left coordinates of a cell. To properly calculate the Top and Left coordinates of a UserForm, you have to take in to account the window state (normal or maximized) of the Excel application window, and the Workbook window, and their relative positions, in addition to whether the formula bar is visible, what command bars are displayed, and how they are positioned. Needless to say, these calculations can get rather complicated. Fortunately, I've done the work for you. (34KB)

GetInfo The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties.

HiLite Highlights the background color of the current selection. (8 KB) NOTE: The functionality of this workbook is replaced and enhanced by the RowLiner add-in.

Latitude Latitude and Longitude data for 1200 US Cities. (62 KB)

Lists Working with 2 lists with duplicate entries. (11K)

MinMax Various Minimum and Maximum formulas. (6 KB)

Names Returning File, Workbook, and Worksheet names to a cell. (6 KB)

NoBlanks Eliminating blanks from a list of data. (7 KB)

Rank A totally new Ranking workbook, which has all the formulas described on the “Ranking Data In Lists" page. (16 KB)

OpenSafe This add-in allows you to safely open workbooks that contain VBA code (macros) without risk. It adds an item to your File menu called "Open Safe". NOTE: The level of protection provided by this add-in is higher in Excel 2002 than Excel 2000. NOTE: Opening workbooks that contain VBA macros always entails risk, so I do not guarantee that this add-in will eliminate all possible risks.

Overtime A file illustrating the formulas on the “Working With Overtime Hours page." (8 KB)

ProgressReporter A DLL file that allows you to display a simple progress indicator. Click here for more details.

Reader Reads cells back to you through your sound card. Adds "Reader" to Tools menu. You should make this into an Add-In. (272 KB, including sound files.) All files must reside in same directory. Yes, that's Chip Pearson's voice reading the numbers.

RowLiner This add-in allows you to have Excel automatically display row and column view lines. See the RowLiner page for more details.

StockWeb Illustrates using Excel to download stock price information from the web. (22 KB)

Symbolize This workbook will display a form that allows you to view and insert special symbols such as currency symbols into your workbook. It works much like the "Insert Symbol" tool in Microsoft Word. (21KB). This works only in Excel97 and Excel2000. It will not work with Excel95 or earlier versions. You can download a better version of this, written as a COM Add-In here. Note that COM Add-Ins are supported only by Excel 2000 or XP. They will not work in earlier versions of Excel.

SumEvery Summing Every Nth Value in a list. (6 KB)

TLIUtils Provides VBA procedures for working with type libraries, via the TypeLib Information object. Documentation of the available procedures is available in the VBA code modules.

Unique Counting Unique items in a list. (7 KB)

VBA Shortcuts This zip file (6 KB) contains a workbook that lists all of the keyboard shortcuts available in the VBA Editor. For a list of keyboard shortcuts within Excel, download Excel Keyboard Shortcuts.

VBE Menus Adding menu items to the Visual Basic Editor (15 KB)

X-Ray Chip Pearsonwrote this game several months ago. It is similar to a game called "Black Box" that he used to play in Junior High. You try to find targets by shooting paths into a grid, and watching whether those paths hit the targets, exit out of the grid, or are reflected back to their original cell. Complete details are in the workbook file. (100 KB) This works only in Excel97 and Excel2000. It will not work with Excel95 or earlier versions.

XLKeys This workbook lists all of the shortcut key combinations in Excel (8KB). Updated 23-April-2001.

XLCAI This download has a sample COM Add-In written for Excel in Office 2000 Developer Edition. It illustrates the basic programming for a COM Add-In, including how to write menu controls, how to handle modeless forms and how to make functions in the COM Add-In available to worksheet cells (via VBA code). The actual download doesn't really do anything, so it will be of interested only to those who want to write COM Add-Ins. You must have the Developer Edition of Office 2000 to view the code. (35KB).

XLConst This workbook lists all the symbolic constants in Excel and their numeric equivalents. The list can be built on the fly using the TypeLib Information DLL.

CPearson.com

54

Excel

Apply Formula to Range Utility

This nifty utility allows you to apply a certain formula to every cell in a selected range. You first select the cells you wish to change, and then run the macro. Winner of the April 2003 MrExcel.com challenge to submit the most useful general-purpose utility for Excel.

MrExcel.com

55

Excel

Multiple: Excel Graphics Utilities

Submissions to the Dec 2002 challenge by this website to find the most innovative uses of Excel related to charts or graphics. Check out the winner - Animated Warehouse Locator!

Entry 1:
BCG Chart by Ed Ferrero

Ed says, "Demonstrates how to create a bubble chart where the bubbles are themselves pie charts. The workbook is useful in its own right for BCG portfolio analysis (Boston Consulting Group). The technique shown here can be used with other types of charts, turning each point in a chart series to an individual pie or other chart. This is one of those 'they said it couldn't be done' charts."
 
Entry 2:
Animated Cannon Chart by Earl Takasaki

Earl writes: While browsing the Microsoft newslists, I ran across a plea from a teacher who wanted to demonstrate simple cannon-ball ballistics. I created an Excel program that uses an “animated chart" to simulate the flight of a cannon ball from a top view on a map. The chart is a simple X-Y chart with a JPEG map of Charlestown bay as the background with points 0,0 centered on the city of Charlestown. I manually scale the X-Y axises so that the scale would equal that of the map in Km. The student enters an amount of powder which linearly translates in muzzle velocity and sets the elevation angle of one of three cannon. (Try Ft Sumter, 7 kg or powder at 35 degrees). After calculating the x-y positions at each point in time, and using translation and rotation to correspond to the cannon and targets on the map, I animate the flight of the cannon towards the target in both a top view and a side view.
The “animation" is done by hiding every line of the data source of an X-Y graph, then unhiding each line one by one using VBA. The “explosion" is done by showing, then hiding increasing sizes of orange dots. Hope you like it!
 
Entry 3:
Demographic Indices by Ken Kranz

Ken writes, This is an example of a spreadsheet I designed to bring together (and compare) an Account and a Brand across a series of Demographic Measures
 
Entry 4:
Interactive Graph without VBA by Vinh Nguyen

Vinh writes, I created this interactive graph without using any VBA coding whatsoever.
 
Entry 5:
Animated Warehouse Locator by Phil Johnson

Phil says, "Just a simple diddy, nothing fancy but rather useful". This is very cool. On screen 1, you select a product. Click the button and an animated path draws how to get to that location in the warehouse.
 
Entry 6:
CD Label Maker by Roy Cox

Roy says, "My entry for the competition uses Excel to create Labels for CDs and Jewel cases. It uses Autoshapes and formating to insert pictures. Text boxes, WordArt etc. can be used to personalise Labels for projects. It prints to Neato and Pressit Labels.
 
Entry 7:
Pricing Sensivity by Ken Kranz

Ken writes, Another (simple/interactive) way I've used charting in Excel to enable a user to "see" potential pricing implications… "nothin' fancy, just Kranzy."

Entry 8:
AutoCAD for Carton Industry by Ron Carroll

Ron writes, This is a program I have been working on for a while now for the corrugated carton industry. It is an inexpensive autocad program designed for that industry to create production specifications as well as estimates, quotes, Package load tags. As far as corrugated cartons go there are about 30 different carton styles and about 20 different thicknesses of corrugated board that can be used to make each. Depending on what combination is used it changes the allowances used in designing the carton. Currently the average small business owner buying cartons has no way to design the cartons they need. So this program is an inexpensive way to do it, it is a combination of excel and vba and as I said it has a long way to go yet, This copy is just a sample I did for one style of carton and it shows how you can import graphics and and printing to the specification. The actual program has all of the carton styles listed in a vb form window so the user can create any style he may need.

Entry 9:
Sorted Pareto without VBA by Henrick Wendel

You have to download this one to see how cool it is. All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values.

Entry 10:
Western Canada Grid System Maps by (contributor name removed at request of contributor)

This is a series of maps that were created created using Excel. The maps calculate the theoretical grid systems in Western Canada. The Dominion Land Survey (DLS) in Alberta, Saskatchewan, Manitoba, and the Piece River Block of British Columbia, and the National Topographic System (NTS) in the remainder of British Columbia. I created these routines as a prototype for a WEB GIS application that is currently in use by Enermarket Solutions. I used Excel to test out the calculations by using Excel to plot out the results. If you are interested, you can check out the production version at Enermarket's web site by downloading their EnerMap application. Normally I would fill in the coordinates of the area to plot and then hit the "map" button to generate the mat then I had some navigation buttons to zoom in/out and north/south and east/west. The sheets that I have shown are the output of the routines that remain proprietary.
 
Entry 11:
Alberta Pricing Map by (contributor name removed at request of contributor)

This second file shows a map of Alberta along with the Nova Gas Transmission pipeline system. In this example I used Excel to plot circles at the location of receipt meter stations and I varied the color of the circles to represent different price levels. This gave a quick visual representation of the results of a rate calculation. This work was done in relation to rate design work for the pipeline system. As you can imagine, we went through a lot of rate calculations and this map was very useful in showing the results of those calculations, certainly quicker than the traditional rate schedules that are essentially tables. This particular example just plots the meter stations on the map. But in actuality the outline of the province and the plot of the pipeline system were also created with excel. I originally used the map to display properties of the pipeline system rather than the meter stations in relation to hydraulic simulation results. As you can see in this map as compared with the above map, I included an orthographic projection that makes it more ascetically pleasing. Examples of these maps can be found on TransCanada Pipelines's web site in the regulatory and tolling pages and are referred to as "dot maps"

Entry 12:
Schematics Example by (contributor name removed at request of contributor)

This last file overlays information from an excel spreadsheet on top of an existing drawing. The attached file shows one use of this type of mapping, the status of individual pipes in the pipeline system relating to an allocation methodology being developed for cost modeling. The different colors relate to being in-service, retired, out-of-path, etc. In addition to the different line styles to represent different data, I'm also able to include labels directed either at the pipe units or the nodes. This involved a bit of work because of the vast amount of information being represented. I started out by copying in the scanned pages from a pipeline line schematics book into Excel. The attached file only contains one page of the pages. I then drew lines on top of the schematics and recorded the x and y position of all the points in the lines into a separate spreadsheet. This separate spreadsheet then was the cross reference between the unit/pipe name and its location in the excel file i.e. the workbook, sheet, and location. Having this information I could then just take the unit name and attach some information to it such as age. I could then use a routine to go through my list get the unit name and draw it over the correct drawing in the correct sheet and format it according to the Information I provided for it or add a label to the unit with the information I want displayed. As it turned out, this particular mapping has turned out to be very useful. Because in addition to the straight plotting of information on a familiar diagram, this also provided an excellent cross reference of where each of the pipe and node units were located in the schematics. For confidentiality reasons I have had to smudge some of the details on the original drawing.

Entry 13:
Interactive Chart by Prashant Nans

This is a nice management reporting tool. Select the product line from the dropdown, and click the blue button to have a small macro re-filter the data and present the chart.

MrExcel.com

56

Excel

Multiple: Excel Games

Submissions to the Oct 2002 challenge by this website to create a game or diversion in Excel. The Challenge specifications should give you an idea of what to expect - "Create something that will be interesting enough to cause other people to waste their valuable time playing the game!"

Entry 1:
Drive by Sean O'Sullivan

Sean says: "This one is similar to those old fashioned ZX81 games (an old UK Computer that was about 5 years before the PC was invented!!!) My game is still a little un-refined as its basically 2 lunch times and tonight finishing off..."
 
Entry 2:
Memory by Chris Leonard

Nice version of the children's memory game. Double click 2 squares to reveal the colored tiles underneath. The goal is to identify all matching pairs.
 
Entry 3:
3D Tic Tac Toe by Tim aka Bolo

Cool version of 3D tic tac toe.
Entry 4:
Screen Soother by Matt Naumann

A screen soother. Best viewed in 1028 x 768, the screen soother features colors that rapidly change in stunning patterns.
 
Entry 5:
Life by Jerry Hunter

A nice Excel version of the classic Life simulation. Comes with a number of pre-programmed start points or draw your own.
 
Entry 6:
FootyLeague by Russel Piper through Ivan Moala
FootyLeague by Jonathan Davies

Fantasy Soccer League (for our U.S. readers) or Football League (for everywhere else). Select the team you wish to own and run a simulation of the season. Jonathan Davies wrote the original simulation a few years ago. He shared it with a few mates and it was passed on to many people. There were bugs in the original version that became widespread. We offer two versions here, one last enhanced by Russel Piper, and the latest directly from Jonathan Davies with all of his latest bug fixes.
 
Entry 7:
Magic 8 Ball by Rich Needham

Rich says: "Here's my MagicEightBall program, more diversion than game. It's a fairly simple program using a random function to select from 60 different answers. Just ask a question which can be answered by "yes" or "no" and click around the MagicEightBall in the window to get your answer. Click again to reset the window. Click the small "X" button in the MagicEightBall window to exit the program. Just for fun, try grabbing the MagicEightBall window by the titlebar and dragging it around the screen to see a cool effect.
 
Entry 8:
Hangman by Joseph Cognard

Hangman. See, I am about to get hung in this initial game....
 
Entry 9:
Snakes & Ladders by Bob LaLonde

Nice game - visually appealing. Great for the kids. Bob says: "Snakes & Ladders. You can play with 2 players or Autoplay. I made this to amuse my son one rainy day, when the internet was slow.
 
Entry 10:
Tic Tac Toe 4x4 by Barry Tocher

Barry says: "Click on box that you want to put your x or o, Then click on the x player or o player button. To restart the game click on the start button" Bill says: I can't get this to work in XP - the color schemes must be different.
 
Entry 11:
Snake by Jochen Wriske

Wow! I couldn't put this one down. The classic snake game. You need to maneuver an ever-growing snake around the grid, trying to each the black squares and not running into yourself. As the snake lengthens and the speed increases, this becomes increasingly challenging.
 
Entry 12:
Master Mind by David Tate

David notes that this game requires RANDBETWEEN, so you have to have the analysis tool pack turned on. Nice implementation of the Master Mind peg game. The computer selects a random sequence of numbered pegs. You try to guess the number and sequence of the pegs and in response the computer tells you how many you have in the right sequence and how many you've selected the correct peg number but it is in the wrong sequence.
 
Entry 13:
Color Game by IOANNIS TSIAMADANIS

Ioannis writes: This is like the Rubic cube but not 3D, just 2D, the game is like the bonus stage in an old coin op game 15 years ago but I cant remember its name.
The goal is to make the colors match the target. First, left-click a square outside of the color tiles to get the right arrow to appear. Then right-click the arrow to rotate the squares in that row, column, or diagonal. The first color becomes the last; the second become the first and the last become second (to the direction you right click). Beat the clock - you have 1.30 minutes to solve every Board. If you take longer than that, you get no points.
 
Entry 14:
Tiles Game by IOANNIS TSIAMADANIS

Ioannis writes: The second one it looks like Tetris but it is not Tetris. It uses the Tiles like Tetris. The idea is to put Tiles together to make "floor" with specific dimensions such as 3x5, 3x20, 4x15. Every "floor" is a Level in the game, if you solve one Level (level 1 is 3x5) then you go to the next Level (unless you want to find another solution to win extra points) .. and so on .. until you go to the last Level, which is 6x15. The points-score for each level is equal to its dimensions, 3x5=15 points, 4x10=40 points and so on. The Tiles are 12, Every tile has 5 square cells. The levels where the Area of Floor is equal to 60 are the most difficult, because you must use all the tiles in a specific order and "shape" (Every tile have mirrors or rotated shapes relative to its self).
 
Entry 15:
Knights Game by Andy Pope

This is a solitaire game where the object is to move all of the BLUE marbles from ABOVE the line to BELOW the line and all of the RED marbles from BELOW the line to ABOVE, using a single space to move. Double click any marble to move it to the empty space. Each marble moves the same way as a knight in a game of chess - 2 spaces either horizontally or vertically, and then 1 space vertically or horizontally - forming an L.
 
Entry 16:
ExcellonII by Koichi Tani, translated by Colo

This is an impressive shooting game. Move the rocket with your arrow keys and fire at incoming targets. Hit the powerups for more power. This definitely gets the award for looking the least like Excel!
 
Entry 17:
3D Tic Tac Toe by Steve W (White6174)

Play against the computer in a 3x3x3 Tic Tac Toe board.
 
Entry 18:
Snake by Colo

Colo's Snake game. This looks impressive, but something is causing it to GPF on my XL2002 machine.

MrExcel.com

57

Excel

Multiple: Excel VBA downloads

Multiple Excel VBA downloads provided by Martin Green of FontStuff.com.

Pop-up Calendar Add-In for Excel
A fully-working Add-In (.xla) for Excel which opens a calendar when the user right clicks on a cell and chooses Insert Date or uses the shortcut CTRL+SHIFT+C. The file accompanies the Excel VBA tutorial A Pop-up Calendar for Excel. It is also available as an Excel workbook [Excel 97, 2000, 2002]

Introduction to Excel VBA: 1. Macro Basics
This Excel file and its accompanying notes guide you through the principles of recording macros and show you how to edit a recorded macro. [Excel 97, 2000, 2002]

Introduction to Excel VBA: 2. Using Loops
Loops are the one of the core tools used by the VBA programmer. This file contains several different examples and demonstrates how and why they are used. [Excel 97, 2000, 2002]

Introduction to Excel VBA: 3. Messages
Communicate with your users! Message boxes and Input boxes provide an easy way to interact with the user when your code runs. This file has several examples of both. There are no additional notes - check out the code and you'll find all you need. [Excel 97, 2000, 2002]

Introduction to Excel VBA: 4. User Forms
Master UserForms and you are on your way to creating full-scale applications in VBA. This file contains an example form and the accompanying notes explain how the code works. [Excel 97, 2000, 2002]

FontStuff.com

58

Access

Multiple: Access VBA downloads

Multiple Access VBA downloads provided by Martin Green of FontStuff.com. Includes Pop-up Calendar Add-in for Access, Cascading Lists, and more!

Fontstuff Database
This sample database contains two tables - one containing the personal details of the staff of a fictitious company and the other containing the addresses of that company's offices. The staff table contains over 1000 records. I have used this database as the example in many of the Access and Access VBA tutorials. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Access Pop-up Calendar Demo
A sample database to accompany the tutorial A Pop-up Calendar for your Access Forms. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Cascading Lists Demo
A sample database to accompany the tutorial Cascading Lists. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Multi Select Demo
A sample database to accompany the tutorial Making Sense of List Boxes. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Coloured Tabs Demo
A sample database to accompany the tutorial Coloured Tabs for Your Access Forms. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Combo Box Date Chooser Demo
A sample database to accompany the tutorial Build a Combo Box Date Chooser. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Access and SQL Part 4: Building Queries "On the Fly"
A sample database to accompany the tutorial Building Queries On the Fly. It contains a table of sample data and the two forms containing the features described in the tutorial.

Access and SQL Part 5: More Instant Queries
A sample database to accompany the tutorial More Instant Queries. It contains a table of sample data and the two forms containing the features described in the tutorial.

Access and SQL Part 6: Dynamic Reports
A sample database to accompany the tutorial Dynamic Reports. It contains tables of sample data, a report and the five dialog box forms featured in the tutorial.

FontStuff.com

59

Word

Multiple: Word VBA downloads

Multiple Word VBA downloads provided by Martin Green of FontStuff.com.

Automatic Document Template
A fully-working template for Word which employs a VBA UserForm to help the user fill in a standard letter. This file accompanies the Word VBA tutorial Build an Automatic Document Template for Word. [Word 97, 2000, 2002]

Simple Pop-up Calendar
A fully-working template for Word containing a Pop-up Calendar UserForm. Install this file in your Word Startup folder. This file accompanies the Word VBA tutorial A Pop-up Calendar for Word - Part 1: A Simple Calendar. [Word 97, 2000, 2002]

FontStuff.com

60

VBA

VBA Course Handbook

This handbook is published as a set of self-contained modules, each on a different aspect of VBA. Each module contains comprehensive illustrated notes and is accompanied by one or more practical exercises. Each one is supplied in both in both Microsoft Word (*.doc) and Adobe Acrobat (*.pdf) format.

FontStuff.com

61

Access

Multiple: Access Examples

A compendium of Access 97 and 2000 routines, each separated into its own database. Each database illustrates one or more possible solutions to a single problem. They are not intended to be fully functioning utilities, but rather an illustration of how the problem might be solved and are therefore intended for educational use. These routines are entirely free. You may use them anywhere and in any way you choose, with or without citation.


A

Animation.mdb (intermediate)
This sample shows how to implement a variety of simple animations in an Access Form.

AreaCodes.mdb (expert)
This application is a utility to programmatically modify Area Codes. It illustrates a number of techniques. It reads files from a directory. It parses CSV files. It reads tables in the database and fields within the tables. It steps through a list (C

AuditTrail.mdb (intermediate)
This sample illustrates one way to produce a simple audit trail table containing: machine name, login name, user name (access security), record number, field name, original value, new value, and a date/time stamp.

AuditTrail2.mdb (expert)
This sample is a more advanced version of AuditTrail.mdb

AutonumberProblem.mdb (beginner)
This sample illustrates a number of ways to simulate your own Autonumber primary key.

 
B
 
BackUpWithCompact.mdb (intermediate)
This sample illustrates how to back up a database using the Compact Method. It creates a backup file called "BackUpWithCompact2kXX_XX_XXXX.mdb" with the X's representing the data. It puts this file in the same directory as the database. It also looks f

BoilerPlate.mdb (intermediate)
This sample is a useful template for an application.

BoilerPlate2.mdb (intermediate)
This sample is a useful template for an application. It is mostly the same as Boilerplate.mdb but with a different MainDataEntry Form.

Books.mdb (intermediate)
"Books.mdb" and it's companion database "Books_be.mdb", make up a simple personal book inventory database. It uses the "BoilerPlate.mdb" sample to create a complete application.

 
C
 
CalculateSpec.mdb (beginner)
This sample automatically calculates the Start Bit of an ImportSpec by adding the Start Bit and Length of the previous record.

CascadingComboBoxes.mdb (beginner)
This sample illustrates how to restrict the value of one combo box based on the value of another.

CascadingComboInSubform.mdb (intermediate)
Illustrates how to use Cascading Comboboxes in a continuous subform.

ChangingColorFields.mdb (beginner)
This sample illustrates how to change the color of a control on a form based on information in the form. In this case, if Check 14 checkbox is checked then the values of Desc will be red, otherwise it will be blue. You can also check for values in t

CharacterScramble.mdb (intermediate)
This application illustrates to scramble character data WITHIN A FIELD. To Randomize FIELDS WITHING A TABLE, see my sample Datascramble.mdb.

ChooseReportFields.mdb (intermediate)
This sample very roughly illustrates how to create a query programmatically which chooses the FIELDS to be reported on a report based on the selected values of a multi-select list box.

ChooseReportFieldsRows.mdb (expert)
This sample very roughly illustrates how to create a query programmatically which chooses the FIELDS to be reported on a report based on the selected values of a multi-select list box and then allows the user to specify the ROWS to be reported.

ChooseReportFromList.mdb (beginner)
These forms illustrate how to create a clean form for launching reports.

ChooseReportFromList2.mdb (intermediate)

These forms illustrate some advanced features in a "Report Switchboard". For less complex examples, see "ChooseReportFromList.mdb"
"Choose Report or Parameter Form" allows the user to select either a report directly or a form in which

ChooseReportFromList3.mdb (intermediate)
This sample shows an alternate way to open reports with a parameter form. It allows the user to select either a report directly or a form in which they can choose a parameter for the report.

CleanFileHTML.mdb (intermediate)
This sample removes the HTML tags from an html document and writes it into a separate text file. See Module 1 for the code.

ComboChoosesRecord.mdb (beginner)
This illustrates how to have a combo box in which you can choose a value and have that record appear in the form.

CompactBackEndDB.mdb (expert)
Illustrates how to compact a Back-End database from the Front-End.

CompactDatabase.mdb (expert)
This sample illustrates how to compact the current database programmatically. It assumes that the tables reside locally. (To compact a Back-end database, see my sample "CompactBackEndDB.mdb".)

CompareTwoTables.mdb (intermediate)
This sample shows how you can programmatically compare two tables and write out the differences to a third table.

ConditionalFormatting.mdb (beginner)
This sample illustrates how to change the color of a control on a form based on information in the form. In this case, if Check 14 checkbox is checked then the values of Desc will be red, otherwise it will be blue. You can also check for values in t

ContinuousFormWithNewRecordOnTop.mdb (intermediate)
This sample illustrates two ways to have a continous form with the new record on top. The first method uses unbound controls in the header of the form and the second uses a bound subform set to Data Entry.

ConvertDateTimeToFormattedString.mdb (intermediate)
This sample shows how to calculate the difference between two times and display the result in 'xx days, xx hours, xx minutes' format.

ConvertStringStuff.mdb (intermediate)
Demonstrates how to convert a variety of strings into their numeric equivalents and back.

CopyObjectsFromBE.mdb (intermediate)
This sample demonstrates how to copy objects from the Back-End database into the Front-End. In this specific case the objects are queries.

CreateDescriptionProperty.mdb (intermediate)
This sample demonstrates how to create and modify the "Description" property of the following Database objects: Tables, Table Fields, Queries, Query Fields, Forms, Reports, Macros, and Modules.

CreateMultiSelectQuery.mdb (intermediate)
This database illustrates how to create a query programmatically based on the selected values of a multi-select list box.

CreateQueries2.mdb (intermediate)
This database illustrates several examples of programmatically creating queries.

CreateQueries3.mdb (intermediate)
This form shows how to create a query programmatically from a form with option boxes.

CreateQueries4.mdb (expert)
This form illustrates how to create a relatively flexible inter-active query facility for an end-user. It allows you to choose the table, then shows the fields available for that table and then values available for the fields.

CreateQueries5.mdb (expert)
This set of samples illustrate how to create a flexible query generator for your users. It is similar to CreateQueries4.mdb, but no longer limits the query to 3 criteria.

CreateQueryFields.mdb (intermediate)
This sample illustrates how to programmatically create a query based on a table or another query and select only those fields that you want to see. It also has a form, which shows how to restrict the rows based on a criteria.

CreateTableFromLinked.mdb (intermediate)
This sample illustrates how to create a native Access 2000 table from a linked Excel table. This process can be easily modified to do the same thing for linked Text or ODBC tables.

CrossTabReport.mdb (intermediate)
The problem with crosstab queries has always been that if you try to make a report based on one, you inevitably have problems with field names when the crosstab changes. This sample demonstrates how you can get around this problem.

CSVtoFixed.mdb (intermediate)
This sample reads a CSV file and exports it as a fixed width file. Module 1 (CSVtoFixed) does the entire process in code. For very large records, Module 2 (CSVtoFixed2) uses a table to allow you to create your own Export Spec.

CurrentTab.mdb (beginner)
This form illustrates how to programmatically scroll between tabs of a tab control on a form. See the code behind the buttons for details.

 
D
 
DAO.mdb (beginner)
This database contains various examples of Data Definition Language (DDL) and Data Manipulation Language (DML) of both DAO and SQL.

DataEntryMask.mdb (beginner)
This sample illustrates a way to restrict what kind of characters are input into a textbox without using an input mask. This method checks the characters as they are typed and only allows legal characters.

DataScramble.mdb (intermediate)
This application illustrates how to scramble data in a table for confidentiality reasons. To scramble Text data WITHIN A FIELD, see my sample CharacterScramble.mdb.

DateStuff.mdb (intermediate)
This example illustrates how to do a variety of date calculations like: First day of Month, Last Day of Month, First Day of Next Month, First Day of Current Week, Last Day of Current Week, First Day of Current Work Week, Last Day of Current Work Week.

DeleteTablesAtStart.mdb (beginner)
This sample illustrates how to delete ImportError tables at start up. For illustration purposes, the RunMacro button executes the code, but if you rename the macro to AutoExec, it will run each time the database opens.

Denormalize.mdb (intermediate)
This example takes data in a normalized table and writes it to another table in denormalized form.

DirectoryList.mdb (intermediate)
This sample shows how to "role your own" directory/file list.

 
E
 
EmailingSpecificReports.mdb (expert)
This illustrates how to email the same report with different data to a variety of users.

ExportFormattedFixed.MDB (intermediate)
This shows how to export to a fixed width text file programmatically.

ExportToExcel.mdb (intermediate)
This sample demonstrates how to export data from a database using the TransferSpreadsheet method, but have the data populate a formatted spreadsheet. The trick here is to export the data to a NEW tab in the Excel workbook and link the fields from the new

ExpressionEvaluation.mdb (intermediate)
This form illustrates how to make a pop-up dialog to calculate values to put into a field on a form.

 
F
 
FlatFileDemo.mdb (beginner)
This example illustrates some of the difficulties inherent in bad (non-normalized) database design and how they can be corrected. It is not a formal tutorial on Normalization, rather it is a series of examples which allow you to demonstrate the kind of tr

FormSubform.mdb (beginner)
This form illustrates how to use Domain functions to do a variety of tasks in a Form/Subform situation.

 
G
 
GetPathFileName.mdb (intermediate)
This form shows how to extract just the Path or just the File name from the db.Name property.

Greenbar.mdb (beginner)
This sample illustrates how to make your report a "greenbar" report that is one that has alternating lines of color. Check behind the individual reports for the relevant code.

 
H
 
HasContinued.mdb (intermediate)
This example illustrates two methods of how to work around the 'HasContinued' bug, so that you can get a 'Continued' status for group headers within a report.

I
 
ImplementingM2MRelationship.mdb (beginner)
This example illustrates two different methods of implementing in a form a Many-to-Many relationship that has been resolved by a linking table.

ImportHTML.mdb (intermediate)
This sample illustrates how to use the LineInput statement to import text from a text file in an extremely unconventional format. The file is an HTML file, and the code searchs for the HTML tags to find specific information and puts that in a field.

ImportLineInput.mdb (intermediate)
This sample illustrates how to use the LineInput statement to import text from a text file with a mixed format. Each line of the file is a separate record, but is delimited in a variety of ways.

ImportSpreadsheet.mdb (intermediate)
This sample illustrates 3 things:
1) How to back up a database using the Compact Method,
2) Create a native Access 2000 table from a linked Excel table
3) Import data to an existing table.

ImportToTempDatabase.mdb (intermediate)
This illustrates how to programmatically create a database to hold a temp table for updating.

ImproveFormPerformance.mdb (intermediate)
One way to improve the performance of a form that is bound to a LARGE dataset is to split the data into smaller chunks. This form uses the "Phonebook" method to do that. The idea comes from those flip-phone indexes. Click one of the 27 buttons at the t

 
K
 
KeepingDatabasesInSync.mdb (intermediate)
Illustrates a method for keeping Access Front-Ends in sync with a Master Network Copy. Uses a DOS batch file.

KeepingDatabasesInSync2.mdb (intermediate)
Illustrates a method for keeping Access Front-Ends in sync with a Master Network Copy. This is an "All Access" solution, so does not require a batch file.

 
L
 
LinkTables.mdb (intermediate)
This example illustrates how to programmatically link tables from a users designated database.

LinkTextFiles.mdb (intermediate)
This sample illustrates how to programmatically link TEXT files to your database.

ListBoxExcludeOnClick.mdb (intermediate)
This sample illustrates two ways to remove a value from a bound list box after it has been selected (double-clicked).

ListBoxSetTableValue.mdb (intermediate)
This sample illustrates how to use a list box to update a "Selected" field in a table and also read which items are selected in the table and set those list box items to True.

ListBoxSorting.mdb (intermediate)
This sample database show various ways of sorting a listbox by clicking on the header of each column.

ListboxSubform.mdb (intermediate)
This sample illustrates use a list box to simulate a simple subform. The user can either double-click the listbox or click the edit button. Then a popup form appears which allows him to select multiple values. These values are written to a separate tab

ListBoxTypeIn.mdb (intermediate)
These forms illustrate how to use a binary search routine to jump to a value in a list box as you are typing in a text box. It is similar to how the Index tab works in Windows Help files.

LogUsersOff.mdb (intermediate)
This sample illustrates how to automatically log all of your users out of an application for maintenance purposes.

LogUsersOffNonUse.mdb (intermediate)
This sample illustrates how to automatically log your user out of an application after a period of inaction.

 
M
 
MaxQueryProblem.mdb (beginner)
The Problem: You want to create a query which will return a MAX Date and the corresponding Amount, grouping them on the Customer Name.

Median.mdb (intermediate)
Surprisingly, Access has no Median function, so you have to write one of your own. This sample database shows how to do that.

MoveList1.mdb (intermediate)
This example illustrates how to move values between list boxes much like many of the Access wizards.

Movelist2.mdb (intermediate)
Illustrates how to move values between multi-select list boxes much like many of the Access wizards.

MoveUpDownList.mdb (intermediate)
This sample illustrates how to make items in an unbound listbox move up and down in the list.

MultiColumnListBox.mdb (beginner)
Access Listboxes do not allow multiple columns that 'snake'. In order to build the funtionality, you must use multiple listboxes. This sample shows how.

MultipleLabels.mdb (intermediate)
This form illustrates how to print multiples of specific labels.

MultipleLabelsOffset.mdb (intermediate)
This sample is a more complete version of MultipleLabels.mdb. It is meant to be a simple minded stand-alone address label program.

MultipleLabelsOffsetBatch.mdb (intermediate)
This sample is a similar to MultipleLabelsOffset.mdb, but prints multiple labels for multiple people in a batch.

MultiSelect.mdb (intermediate)
Form illustrates two methods how to write values selected in a multi-select list box into a table.