| 416-621-9348 cgreaves@chrisgreaves.com | .JPG) |
|---|---|
| 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
Referencing A Library
We need to tell our macro library workbook (Under001.xls) about our compiled function library (UX001.XLA).
We achieve our goal with the Tools, References command in the Visual Basic Editor:
Use the Browse button to navigate to your AddIns folder:
You will need to switch to files of type XLA.
That done you will see your project in the References list; make sure that the check box is checked ON!
Your Under001.XLS code will now compile cleanly.
What’s more, it will run!
Loading
Toronto and Mississauga, Friday, December 03, 2010 8:45 AM
Copyright © 1996-2010 Chris Greaves. All Rights Reserved.