Functions included in add-in

[Tony McGee]

Hello all

I have written an Excel add-in that amongst other things, includes some
custom functions that appear in the "User Defined" category of the Excel
function list. These functions are contained in a separate module within my
add-in.

Is there an easy way (or any way) of making these functions freely & easily
distributable by anyone who uses them WITHOUT requiring that other users get
my add-in. ie, if someone has my add-in, uses some of these custom functions
in a workbook, then wants to send that workbook to somebody else who does
not have my add-in.

They are of course public functions that enhance Excel. They are not for
"internal use" within my add-in.

Hope this makes sense

--

Thanks

Tony McGee
St Agnes Catholic Parish
Port Macquarie NSW 2444
Phone (02) 6588 7444

 

[Guest]

No. Anyone using the spreadsheet with the UDF's in is is going to need to
have the addin. You run into the same issue with functions from the Analysis
Toolpack. If the user has not installed the toolpack then they can run into
problems...

 

[Chip Pearson]

You can't "disassociate" the functions from the add-in in which they are
defined. If a workbook utilizes functions in an add-in, all users of that
workbook must have the add-in; without it, they'll get #NAME errors.


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

 

[Alan Beban]

You can't "disassociate" the functions from the add-in in which they are
defined. If a workbook utilizes functions in an add-in, all users of
that workbook must have the add-in; without it, they'll get #NAME errors.

What am I missing? Can't individual functions be copied and pasted from
an Add-In file module into a workbook general module and be fully usable
in that workbook sent to another user SO LONG AS THE FUNCTION IS
INDEPENDENT OF ANY OTHER FUNCTIONS IN THE ADD-IN?

Alan Beban

 

[DS-NTE]

Of course you can as long as you have the add-in, it is unprotected or you
know the password.

knut

 

[gimme_this_gimme_that]

Could you add a method to your addin that exports sharable addin
macros into a VBA module and inserts that module into the current
workbook?

You may have to modify your add-in macros so they can be run as both
add-in macros and workbook macros, that is, by having Workbook and
Worksheet parameters to all the Subs and Functions, but it's not a big
deal.

Check out the Subs and Functions for the VBProject object to get
started.