Can I "compile" VB into an executeable program?
I've got a bunch of macros in my workbook (500kb). This workbook
will be used as a template for others to use, enter data and run the macros. Is there a way to compile the VB so that it won't take up so much space? thanks chuck |
Can I "compile" VB into an executeable program?
Chuck,
VBA does not produce .exe. What you can do is store all the macros in an add-in and place it on a shared network drive where all users can access it from, without each keeping their own copy. This is even more important if the template is to be saved as different workbooks often, each containing all the code in the template! Moreover, the add-in approach allows you to do code modifications, if required, in one place, and available to all users. HTH, Nikos "ChuckM" wrote in message m... I've got a bunch of macros in my workbook (500kb). This workbook will be used as a template for others to use, enter data and run the macros. Is there a way to compile the VB so that it won't take up so much space? thanks chuck |
Can I "compile" VB into an executeable program?
You can create compiled COM or managed code add-ins as DLLs using Visual Studio.
-- (ChuckM) wrote in message om... I've got a bunch of macros in my workbook (500kb). This workbook will be used as a template for others to use, enter data and run the macros. Is there a way to compile the VB so that it won't take up so much space? thanks chuck |
All times are GMT +1. The time now is 06:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com