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

"David Evans" wrote in
:

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()

--
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and want to reply.