Common VBA procedure library

T

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
 
K

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
 
T

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
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top