Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make VB programs external?
I have a workbook with 500k of VB. Is it possible to externalize the
VB code so that other workbooks can reference it and execute the programs...without loading the VB? thanks chuckm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make VB programs external?
Yes, put your code in an addin.
See Jan Karel Pieterse's tutorial at: http://www.jkp-ads.com/Articles/DistributeMacro00.htm http://support.microsoft.com/?id=167909 XL: Securing Visual Basic Code in Microsoft Excel http://support.microsoft.com/?id=156942 XL97: How to Create an Add-in File in Microsoft Excel 97 http://support.microsoft.com/?id=211563 How to create an add-in file in Excel 2000 http://msdn.microsoft.com/library/en...xceladdins.asp http://msdn.microsoft.com/library/en...exceladdin.asp http://www.j-walk.com/ss/excel/tips/tip45.htm Excel 97: Creating Add-Ins -- Regards, Tom Ogilvy "chuckm" wrote in message ups.com... I have a workbook with 500k of VB. Is it possible to externalize the VB code so that other workbooks can reference it and execute the programs...without loading the VB? thanks chuckm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make VB programs external?
No. The VBA code, whether in a file or add-in, must be loaded in
order to run. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chuckm" wrote in message ups.com... I have a workbook with 500k of VB. Is it possible to externalize the VB code so that other workbooks can reference it and execute the programs...without loading the VB? thanks chuckm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run external programs | Excel Discussion (Misc queries) | |||
Copying Excel 2007 data to external programs | Excel Discussion (Misc queries) | |||
How to make up an excel book that I can import other programs in | Excel Worksheet Functions | |||
Column Selection using external programs | Excel Discussion (Misc queries) | |||
Running external programs | Excel Programming |