How To Build an Excel Library

416-621-9348 cgreaves@chrisgreaves.com
Home Site About 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

To build a library of macros we draw on a library of functions.

Remember that a macro is a subroutine with no parameters.

End-users, including us developers, can run only macros from Excel (or word etc.) macros are our door to useful stuff written in VBA.

Remember that a function is a procedure that can return a result computed from none, one or more arguments.

Developers like us, but not end-users, can call functions from functions and macros.

A library of macros is therefore a collection of macros, and little else.

The macros make use of functions held in a library of functions,

In consequence, if you have just attended a course on macros and the instructor recommends that you build a library of macros, you will probably build TWO libraries in parallel.

Any macro that you write will be stored in your macro library. The macros you write will need functions; you’ll write those functions too, but you’ll store the functions in a function library.

So don’t be surprised to find in these notes my discussion of “Write a function to do this, and store it in your function library” and “Write a macro to do this, and store it in your macro library”.

You gotta start somewhere

Toronto and Mississauga, Thursday, March 18, 2010 7:50 AM