Calling function from non-referenced add-in
s = Application.Run("myAddin.xla!fct_name", arg1, arg2)
Inclusion of the addin name may not be necessary if there's no ambiguity of
the procedure name in any open project.
Regards,
Peter T
wrote in message
...
Hello,
I've tried researching this topic but it is still not clear to me what
the correct syntax is, or if this is even possible.
Inside one sub, I would like to call a function in an add-in, but want
it to work if the add-in is not necessarily referenced in the project.
Ex.
str = fct_name( arg1, arg2)
This works if I reference the add-in.
str = (?)fct_name(arg1, arg2)
Isn't there a way to fully qualify this (?) such that the add-in does
not need to be specifically referenced?
Thanks for any input.
Eric
|