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

Animated Color Scales

Category: General Files | [Item URL]

  • Description: A 62x62 range of cells contain simple formulas that use the SIN and COS functions. Color Scales conditional formatting is applied to the range. Click a button, and the colors change randomly. Click another button, and the image rescales randomly. Click the third button, and it moves. Good clean fun for the entire family.

    NOTE: This will not work in versions prior to Excel 2007.
  • Has Macros? Yes
  • Download: animatedcolors.xlsm

Smiley Chart

Category: General Files | [Item URL]

  • Description: The workbook contains a chart that looks like a smiley face. The amount of smiling (or frowning) is determined by the value of a cell. If the cell contains -1, you see a big frown. If it contains +1, the face smiles. Values in between produce a corresponding expression.
  • Has Macros? No
  • Download: smilechart.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

Multiple UserForm Buttons With One Procedure

Category: Developer Files | [Item URL]

  • Description: With a 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.
  • Has Macros? Yes
  • More Information: Click here
  • Download: multiplebuttons.xls

Page 2 of 5 pages
[Previous page]   [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