| 416-621-9348 cgreaves@chrisgreaves.com | .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
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, Monday, September 06, 2010 7:53 PM
Copyright © 1996-2010 Chris Greaves. All Rights Reserved.