image
 
image
VBA Source Code



Color     Config     Constants     DateTime     Digest     ExcelUtils     File     Globals     Health     Log     Math     OutlookUtils     SetCellBackgrounds     SpecialDirectories     StackOfObjects     StackOfVariants     String     Utils     WordUtils

This module provides constants that are Public and therefore usable in any other module. In addition, for each constant, an accessor function is defined. This is because the constants cannot be referenced directly from within an application like Excel or Word and can only be accessed by way of a function.

This module provides a place for routines to place text or values that would be useful to their calling routines. An example of its usefulness is a Boolean Function that returns False if it fails. It would be nice to have a place where text describing the reason for the failure could be put and be made available to the routine that called the Boolean Function. The alternative to using a global like this is to pass a Output String parameter down through all the functions in the call stack.

This module provides miscellaneous utility routines and functions.

This module provides miscellaneous utility routines and functions that operate on Excel objects and variables.

This module provides miscellaneous utility routines and functions that operate on Word objects and variables.

This module provides miscellaneous utility routines and functions that operate on Outlook objects and variables.

This module provides miscellaneous mathematical routines and functions.

This module provides procedures that supplement the String type.

This module provides procedures that supplement the Date type.

This module provides procedures that supplement the File type.

This module provides definitions for finding and using Windows' "special" folders such as "Application Data", "Documents", "Favorites", etc.

This module retrieves configuration parameter values from the config sheet in the current Excel workbook.

This module is for writing one-row messages to the Sheet named "log" if there is one in the current Excel workbook.

This module contains VBA routines for generating digests. It currently supports the MD5 message-digest algorithm as described in RFC 1321 by R. Rivest, April 1992

This module contains routines and functions for manipulating colors. In particular, it provides tools for using the RGB, HSL, and HSV color representations and for moving back and forth between them. The RGB color representation is used by most applications but the HSL color space is much easier for mathematically manipulating colors.

This module implements a Last-In_First-Out Stack data structure for storing entities of type Variant.

This module implements a Last-In_First-Out stack data structure for storing entities of type Object.

This module conditionally formats the background colors for the currently selected range on the active sheet.

This module contains routines for health- and fitness-related computations. For example, it provides a function for computing a person's Basal Metabolic Rate.
Constants Globals Utils ExcelUtils WordUtils OutlookUtils Math String DateTime File SpecialDirectories Config Log Digest Color StackOfVariants StackOfObjects SetCellBackgrounds Health