Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing code in Add-in
"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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing code in Add-in
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" 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing code in Add-in
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 "Jim Cone" wrote in message ... 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" 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing code in Add-in
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) "mike allen" 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 "Jim Cone" wrote in message ... 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" 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing code in Add-in
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" 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 "Jim Cone" wrote in message 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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Storing XML In Workbook | Excel Programming | |||
Storing column() to use later | Excel Programming | |||
storing a value in code | Excel Programming | |||
storing of VBA code | Excel Programming | |||
Storing Data in code? (relative primes to MOD as example) | Excel Programming |