VBA

A class for modifying Excel workbooks, focused on OLAP pivot tables and code modifications.

A basic class for logging to text files in Excel

A class module for Excel or Access, that encapsulates a specific implementation SQL Server data, although most properties are constants within the class, to separate the data interaction from the application. As or methods, it has numerous public methods for invoking stored procedures to retrieve, add, delete, and update records, filtering the recordset, and private methods for establishing/closing connections, verifying user access, verifying version.

Working with Access, I needed to calculate business days between dates, excluding holidays, and with an eventual conversion fo the DB to SQL Server, rewrote the VBA into an SQL function.

Updated an Access DB that queries the domain for objects, e.g., user ID's, along with the related account fields by adding the ability to collect group membership (ACL's) or each account. Additionally, added a form/process that enables querying the domain for single accounts.

Access class module that automates zipping files, with parameters.

Saves toolbar positions in an excel file, allowing a user to restore the toolbar layout at a later date.

Added the ability of send the current workbook via Notes or Outlook. Somewhat rudimentary, although it can try and verify names in the address book, and the Outlook piece has not been tested, but easy enough for someone else to build on.

Class for workdate, and function for count of workdays between days

Function to check the Excel version, 97 to 2007, returning a text string

Toolbar fro many commonly used functions, as well as automated print formatting