Excel XLA Installation - Distribution package. This is a version of my pseudo Excel Installation Package for distribution of your macros!
Design Theory:
Ok, without getting all crazy with the registry and such, package emulates an installation package. Tried to design with noobs in mind. Heavily commented
with decent amount of error checking. This is a hybrid of my thin weight installation package which has been modified and intesified. When opened .xla is actually hidden window.
What is it?
Allows you to package up your Excel XLA into a self contained installation file. Installation process saves file as XLA, then creates toolbar with new button which activates your macro.
How does it Work?
Simple, simply import your forms, and modules, configure the values in Public module.
Features:
-Customizable Button to activate your macro or form
-Customizable word Art Text for installation proccess
-Customizable Background color for installation proccess
-Package has been optimized so that very minimal configuration to deploy your macro.
-Simply configure required public vars, and import your forms and modules.
-Cool interface to give users feel of actual installation.
Important Notes:
-Hidden Help File, simply format->Sheet->Unhide->Help
-Be sure to configure all required vars
-To see how it works, put a break point in it and step through it
-Install package is designed to launch a SINGLE form or macro. Advanced users could probably modify it to do multiples
To see it in action, download file, and hit the install button. Then once you see how it works, modify it with your package. As always, open source, just ask you don't remove my credit. Modify how you like!
[Blocked Image: http://programminglibrary.com/…ary/DOWNLOAD/ExcelXLA.jpg]
To large for post
http://programminglibrary.com/Programming%20Library/DOWNLOAD/Excel%20XLA%20Installation%20Package.xls
Archived Downloads
http://programminglibrary.com/Programming%20Library/DOWNLOAD/downloads.aspx
Happy Coding............
