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
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
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
Mail Merge Demo
Category: General Files / Developer Files | [Item URL]
- Description: Normally, Microsoft Word is used for mail merge operations. Word can perform a mail merge with data stored in an Excel workbook. The process works well, but in some cases it may be preferable to eliminate Word and do all of the work with Excel. This example demonstrates Word-less mail merge.
- Has Macros? Yes
- More Information: Click here
- Download: mailmerge.xls
Range Selection Demo
Category: Developer Files | [Item URL]
- Description: Contains 15 VBA procedures 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.
- Has Macros? Yes
- More Information: Click here
- Download: rangesel.xls
Permutation Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates a recursive VBA procedure to generate all possible permutations of a text string.
- Has Macros? Yes
- More Information: Click here
- Download: permute.xls
Progress Indicator Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates how to create a graphic progress indicator in a UserForm.
- Has Macros? Yes
- More Information: Click here
- Download: progind.xls
[Next page]
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
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: