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

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

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Tony29" wrote in message
news
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

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]" wrote:

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

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Tony29" wrote in message
news
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

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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Tony29" wrote in message
...
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