xla files

[Steven]

Are not macros in an xla file that have been added-in available to be called
from any other excel file for that particular logged on user? If yes, how do
you call the macro?

Thank you,

Douglas

 

[Dave Peterson]

Do you mean from a formula in a worksheet?

If yes, then you should be able to use the UDFs just like they're built into
excel.

If you mean you want to call a procedure via code, you can use application.run

or you can add a reference to the addin in the workbook's project.

Select your project inside the VBE
Tools|References|check the Addin's project.

You'll want to make sure that that addin has a nice unique project name first.

Then you can call that procedure just like it's in your own workbook's project.