416-621-9348 cgreaves@chrisgreaves.com
Home Services Products

How To Build an Excel Library (Home); You Gotta Start Somewhere ; Creating A Function Library ; Compiling A Workbook To A Library ; Creating A Macro Library ; Referencing A Library ; A Toolbar Menu ; Making The Macro Library Available ; Some Minor Points ; Maintaining The Utility Function Library ; End-users And The Utility Function Library

Creating A Function Library

The creation is easy; the design is harder.

Your utility functions will live in modules. How to name the modules and what goes where is tricky, and you may well change your mind down the road.

For now I’m going to create a regular Excel workbook. I’m going to insert a module and name it “modCellData”.

“mod” because it’s a module

“CellData” because it will house functions that manipulate or change the data content of cells.

Here is my proto-library.

Notes:

I have saved the file as UX001.xls. “UX” because it is a Utility eXcel library, and “001” because I’ll be saving successive versions 002, 003 as time goes by, sometimes several times a day. Numbers are free.

I have deleted all but one sheet and renamed that with a web site, in case anyone is curious enough to follow up and needs a clue.

The sole function sits in its module, and has an embedded self-testing procedure. Drag the Sub TESTWipeData out of the function, de-comment it and run it to check that the function works, then re-comment it and drag it back inside.

Compiling A Workbook To A Library

Loading

Toronto and Mississauga, Friday, December 03, 2010 8:45 AM

Copyright © 1996-2010 Chris Greaves. All Rights Reserved.