Using Excel Add-in functions
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 |
Using Excel Add-in functions
"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. |
All times are GMT +1. The time now is 03:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com