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

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

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

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

Yearly Calendar - With Holidays

Category: General Files | [Item URL]


Yearly Calendar Workbook

Category: General Files | [Item URL]

  • Description: A worksheet that displays a yearly calendar for any year between 1900 and 2100. Use the slider at the top to select the year. Change the appearance by modifying the named styles.
  • Has Macros? No
  • Download: yearly-calendar.xls

MP3 File Lister

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

  • Description: An Excel application that generates a list of MP3 files. To use it, click the 'Start" button and you will be prompted for a directory. The list includes the directory you choose, plus all nested subdirectories. When the macro finishes, the worksheet will contain a list of MP3 files with the following columns: Path, Filename, Artist, Album, Title, Track, Genre, Duration, and Size. The data can be summarized in a pivot table. This is not the fastest application, so be patient (the status bar displays the current file number).

    This workbook requires a reference to Microsoft Shell Controls and Automation (shell32.dll). If it doesn't work for you, check the reference using Tools - References in the VB Editor. The VB Project is not protected, so you can view the code or modify it to suit your needs.
  • Has Macros? Yes
  • Download: mp3filelister.xls

Page 1 of 3 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 2017, J-Walk & Associates, Inc.
Privacy Policy