Miscellaneous "Plug and Play" VB Tools

[dflak]

The ZIP file contains the modules themselves. The Word Document has more detailed descriptions.

All these tools are designed to be "plug and play." Download the module into the VBA Project and pass it the right arguments. You should not have to change anything inside the code.

The following are contained in this toolbox:

• Append to Log - Appends a date stamped message to a text log file.
• ASCString - Presents the ASCII values for characters in a string. Useful for debugging dirty data.
• Circular Archive - Keeps last N saves of a document. Useful for "short versioning" and having a recent non-corrupted version of a file.
• Clear Table - clears the data portion of a table.
• Mailer - Sends mail. Includes: To, Subject, Body, ReplyTo, OnBehalfOf ,CC, BCC, Attachments, HTLM Range in body.
• NetWorkHours - Like NetWorkDays - Computes hours worked given shift information and start and end times.
• WorkHours- Like WorkDays - Computes completion time given shift information, start time and number of hours to be worked.