Common VBA procedure library

[Tony29]

I have VBA code in Outlook, Access and Excel which have calls to procedures
which are in fact common across all of these applications. I can put the
common procedures into an .xla so that they are available to .xls workbooks,
but how do I put them into a single repository so that they are avaiable to
any application?

Thanks in advance

 

[Ken Slovak - [MVP - Outlook]]

The only clean way I can think of to do that would be to compile the
procedures into a DLL and load the DLL and call it's exposed methods. Of
course then it's no longer VBA code. Other than that you'd have to load the
workbook with the code and call it from there

 

[Tony29]

Forgetting the .dll suggestion for the moment ... are you saying, for example
that if I use an .xls which I save as an .xla and use this as the
'repository' of common procedures, that I could from within Outlook VBA make
a foreign reference to those .xla procedures (in much the same way as any
other .xls can make a foreign reference to those procedures ? If so, could
you explain how?

or is it a case of 'invoking' an instance of the .xla from within the
Outlook VBA?

If not, I don't understand the implications of your suggestion and I wonder
if you could elaborate.

Thanks

 

[Ken Slovak - [MVP - Outlook]]

It would be invoking an instance of the xla, if that's possible, from
Outlook or whatever other app the code is in. Whether or not that would work
I don't know, that's a question for an Excel group.