storing code in Add-in

[mike allen]

"gimme this gimme that" suggested to me in an earlier post that instead of
trying to delete modules that are protected (which i never figured out how
to do in code), just run these macros and functions that are currently in my
modules in an Add-in. i have no idea how to do this. i have looked in the
chip pearson literature i have, but nothing on this. my goal is to provide
a "program" to a second party, have them run it, producing only output (no
code!) that they can then send to a third party. the second party (nor
third) will not have passwords, but the second party can have code locked in
an Add-in (but not the third party). any thoughts? thanks.

 

[Jim Cone]

Chip Pearson has quite a bit about add-ins here...
http://www.cpearson.com/excel/CreateAddIn.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mike allen" <[email protected]>
wrote in message
"gimme this gimme that" suggested to me in an earlier post that instead of
trying to delete modules that are protected (which i never figured out how
to do in code), just run these macros and functions that are currently in my
modules in an Add-in. i have no idea how to do this. i have looked in the
chip pearson literature i have, but nothing on this. my goal is to provide
a "program" to a second party, have them run it, producing only output (no
code!) that they can then send to a third party. the second party (nor
third) will not have passwords, but the second party can have code locked in
an Add-in (but not the third party). any thoughts? thanks.

 

[mike allen]

it appears i can store functions that have one answer as an .xla add-in, but
what about subroutines that actually calculate certain things, print them in
certain areas, etc.? can i use an add-in for calling subroutines? thx

 

[Chip Pearson]

You can call subs in an add-in from other VBA procedures in other projects
with the Run method. E.g.,

Application.Run "AddInName.xla!MyMacroName"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Jim Cone]

An add-in is simply a hidden workbook.
Any code you put in a regular workbook should work in an add-in.
However, there are things to watch out for including that an add-in is
never the Active Workbook.
I have add-ins with dozens of functions and subs in them.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"mike allen" <[email protected]>
wrote in message
it appears i can store functions that have one answer as an .xla add-in, but
what about subroutines that actually calculate certain things, print them in
certain areas, etc.? can i use an add-in for calling subroutines? thx