Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Porting VBA Libraries
I have a library of VBA procedures in my Personal.xls file consisting o
a half dozen or so Modules, each containing 10 to 50 individua procedures. When developing a new application, this library i referenced. But once the application is “done” and if I wish to mov it to another machine, I need a way to move the necessary procedure from the library as well. My present method uses an application I wrote that interrogates th application, builds a list of procedures called, interrogates thos procedures, etc. When that process is done, a Module is built of al library procedures and added to the Application. It works and onl “adds” the required procedures; but is rather “brute force”. Is there a better way to do this? Is there some simpler way to do thi and keep the library “secure”? I have no particular preferenc regarding how much is moved, i.e., the entire library or just th “necessary” procedures. The latter seems a bit more efficient. Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference Libraries and Add-Ins | Excel Discussion (Misc queries) | |||
Porting Excel 2003 | Setting up and Configuration of Excel | |||
Importing libraries | Excel Discussion (Misc queries) | |||
Porting 16-bit to 32-bit | Excel Programming | |||
Object libraries | Excel Programming |