Using Excel Add-in functions

[David Evans]

I'm having trouble accessing public functions and subs in
and Excel Add-in. I have added the .xla file via the Add-
ins menu option. The Auto_Open and Auto_Close subroutines
activate when I open and close Excel. How do I use the
functions in VBA in my .xls file?

Thanks,
David

 

[Jonathan Rynd]

How do I use the
functions in VBA in my .xls file?

You probably have to refer to the name of the addin in VB when you call the
function, for instance instead of

Initialize()

you call

AddinName.Initialize()