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

Compiling A Workbook To A Library

This is the easy part.

Choose File, saveAs, and from the bottom of the drop-down list choose files of type “AddIn”.

Note that my workbook, UX001.XLS was originally saved in a folder “G:\Greaves\Products\DEVEL\Libraries”

But that once I change the file type to AddIn, the extent will be ".XLA”, and the file will be stored in the folder “C:\Documents and Settings\ChrisL\Application Data\Microsoft\AddIns”.

(Yes, I already have two other libraries from earlier projects!).

Interestingly enough, once the file is saved as an XLA, Excel returns to our original XLS format!

Here is our UX001.XLA stored in my local user ChrisL's AddIns folder.

Creating A Macro Library

Loading

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

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