Common VBA procedure library

Tony29 · Joined: 05 Feb 2008 Posts: 4

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

Archived from group: microsoft>public>outlook>program_vba

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

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 @microsoft.com...
>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

Tony29 · Joined: 05 Feb 2008 Posts: 4

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
> @microsoft.com...
> >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 - Outlo · Joined: 12 Aug 2007 Posts: 405

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 @microsoft.com...
> 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

Procedure Reading Newsgroups Via Outlook 2007 and Windows Vi Doing a search yields scores of posts regarding Outlook 2003 or Outlook 2007 with XP, where the news icon is missing from Outlook. But I have not seen any solution for getting a news icon to show for the Windows Vista and Outlook 2007 combination. One MVP

Business Contact Manager failed to initialize common languag This error message comes up and keeps looping every time I try to acees my Outlook. Business Contact Manager failed to initialize common language routine ecall methods must be packaged into a systme module. Please provide a fix or a suggestion. Thanks

Organisational Form Library I want to be able to load my form into the OFL but I don't have the required permissions. What does my administrator need to give to allow me to publish to this location? Thanks

Microsoft Outlook Object Library Hi, I am trying to use “Microsoft Outlook Object Library”. I have found a site, which mentions same. when I try to run the code given in above site I am getting annoying message saying "A program is trying to acc

Microsoft Outlook Object Library Hi, I am trying to use “Microsoft Outlook Object Library”. I have found a site, which mentions same. when I try to run the code given in above site I am getting annoying message saying "A program is trying to acc