416-621-9348 cgreaves@chrisgreaves.com Visit www.ChrisGreaves.com for this image! Chris_GEDC1894_Head (Small).JPG
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

Some Minor Points

Looking ahead, your macro library filename will increment in sequence, Under001.xls, then Under002.xls, Under003.xls and so on.

Your function library template too will run ahead in sequence.

However, you have enough on your plate maintaining both libraries without having to continually change the Tools, references to point to a differently-named version of the function library.

I recommend that you save your function library as plain “UX.XLA”, and make your macro library refer consistently to “UX.XLA”, then you won’t need to change the reference.

Maintaining The Utility Function Library 



Loading

Toronto and Mississauga, Monday, September 06, 2010 7:53 PM

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