King James Bible

Category: General Files | [Item URL]

  • Description: Version 2, for Excel 2007 and later. Not to be confused with the Excel Bible, by yours truly. This is the King James Bible in an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell. Features: a hyperlink table of contents,summary formulas to calculate key stats for each book, a word count feature, a random verse generator, and a spiffy new Ribbon interface. If you use a version before Excel 2007, here's the old version.
  • Has Macros? Yes
  • Download: king-james-bible.xlsm

Light Box Demo

Category: Developer Files | [Item URL]

  • Description: You've seen Web sites that "go dim" when a window is displayed on top of the page. This is known as a light box effect. This file contains VBA code that demonstrates how to get a similar effect in Excel. It displays a UserForm or a Message Box while Excel's window is darkened.
  • Has Macros? Yes
  • More Information: Click here
  • Download: xllightbox.xls

Word Clock

Category: General Files | [Item URL]

  • Description: Based on a screen saver by Simon Heys. It displays the current date and time in words, updated every second. Completely useless, but you might find it interesting. For Excel 2007 and later.
  • Has Macros? Yes
  • Download: word clock.xlsm

Generate Meeting Bingo Cards

Category: General Files | [Item URL]

  • Description: Generate meeting bingo cards to liven up boring meetings. Contains 186 buzzwords, randomly arranged in a 5x5 grid. Or, customize this file for other types of bingo games (such as political speeches).
  • Has Macros? No
  • Download: meetingbingo.xls

Day Calculations

Category: | [Item URL]

  • Description: A workbook that contains formulas to perform calculation such as the "first Tuesday in October", the "second Sunday in August", and "the last Friday in July."
  • Has Macros? No
  • More Information: Click here
  • Download: datecalculation.xls

Functions To Quantify Color Contrast

Category: General Files / Developer Files | [Item URL]

  • Description: This workbook contains VBA functions that can help you select legible colors for cell background and text.
  • Has Macros? Yes
  • More Information: Click here
  • Download: color-difference.xls

Speech Control Ribbon Enhancement

Category: Add-Ins | [Item URL]

  • Description: Install this add-in, and you'll have a new group on the Review tab of the ribbon: Text to Speech. Use these controls to read the contents of cells.

    This add-in does not work with versions prior to Excel 2007.

  • Has Macros? Yes
  • More Information: Click here
  • Download: speechcommands.xlam

Generate A Word Frequency List

Category: General Files / Developer Files | [Item URL]

  • Description: A workbook that demonstrates a VBA macro that creates a word frequency list. Put your text in Column A, with no blank cells. The text can consist of sentences, titles, etc. Run the macro, and you get a pivot table that lists every word, and the number of times it's used. The demo file contains three examples: Beatles song titles, the first few paragraphs of Moby Dick, and a George W. Bush speech.
  • Has Macros? Yes
  • More Information: Click here
  • Download: wordfrequency.xls

Display Disk Drive Information

Category: General Files / Developer Files | [Item URL]

  • Description: Contains VBA macros that display information about the drives attached to your system. It uses three functions: DriveType, DriveSize, and DriveSpaceFree.
  • Has Macros? Yes
  • More Information: Click here
  • Download: driveinfo.xls

Slide Show Demo

Category: General Files / Developer Files | [Item URL]

  • Description: Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.
  • Has Macros? Yes
  • More Information: Click here
  • Download: chart slide show.xls

Page 1 of 5 pages
[Next page]

Search Downloads


All Downloads

Browse Downloads by Category

Also of Interest

How to download

Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results:

  1. Right-click the download link
  2. From the shortcut menu, choose Save Link As or Save Target As
  3. Specify the location for the downloaded file.
© Copyright 2016, J-Walk & Associates, Inc.
Privacy Policy