portable code...

Hello.

User defined functions can be made available through Add-Ins... write your
code for the function, save it as an .xla file, use Tools-Add-ins to load the
addin, and the function you wrote is available to be used as any other
function.

Is it possible to similiarly use code modules through Add-Ins?

Write a utilitiy module, load the add-in, use the utility from another
file's code modules by calling the subroutine the as you would the code
modules were in the same workbook?

Thanks,
Mark

Are you asking for the syntax for executing a proceedure from a separate
project?

If you do this it will only work on the one machine or require moving
project and addin to any machine you use it on. typically you might try the
personal.xla instead of addin for shared or portable code.


"mark" wrote:

> Hello.
>
> User defined functions can be made available through Add-Ins... write your
> code for the function, save it as an .xla file, use Tools-Add-ins to load the
> addin, and the function you wrote is available to be used as any other
> function.
>
> Is it possible to similiarly use code modules through Add-Ins?
>
> Write a utilitiy module, load the add-in, use the utility from another
> file's code modules by calling the subroutine the as you would the code
> modules were in the same workbook?
>
> Thanks,
> Mark

Unless you create a reference to the addin from the project where you want
to use the code, you would need to use

Application.Run "MyAddin.xls!MyMacro",arg1,arg2

--
Regards,
Tom Ogilvy

"mark" <[email protected]> wrote in message
news:[email protected]...
> Hello.
>
> User defined functions can be made available through Add-Ins... write your
> code for the function, save it as an .xla file, use Tools-Add-ins to load
the
> addin, and the function you wrote is available to be used as any other
> function.
>
> Is it possible to similiarly use code modules through Add-Ins?
>
> Write a utilitiy module, load the add-in, use the utility from another
> file's code modules by calling the subroutine the as you would the code
> modules were in the same workbook?
>
> Thanks,
> Mark