Sharing macros

[redkite]

Hi,
I've created a macro. Now, I wish to share it with (or distribute it to) the
employees in my company.

I know that you can import files in the VBA editor but they are imported
into a new Class. However, they need to be in Microsoft Office Outlook
Objects - ThisOutlookSession so that they can run it as a macro.
I know that you can copy the code to that section but most of the employees
never work with VBA an have never seen the VBA editor.

Is there a way to distribute or share the macro without them having to do
anything in the VBA editor?

Thanx in advance for your time...
Henk

 

[Ken Slovak - [MVP - Outlook]]

You can distribute the entire VBAProject.OTM file but that will overwrite
any macros the users already have.

Distributing macros that way is very hard to maintain and isn't the best
approach. It's far better to code your solution as an Outlook COM addin and
distribute that.

 

[Christian Buehler]

Hello!

This is exactly the same problem I'm having.
When searching for a solution for this, I've already come across the
posibility to create COM-Add-Ins. But on the page where it was
described how to do that, it said, in order to create a new add-in,
open the Visual Basic Editor within Excel and click File -> New... ->
New Add-In (or somehow similar, I don't know the exact words any
more).
My problem now is that there is no option "New" at all.

So how can I create such a add-in?

Thanks,
Christian

 

[Ken Slovak - [MVP - Outlook]]

Outlook is not Excel.

To create a COM addin for Outlook you need a programming language such as
VB, C++, C#, Delphi or Office Developer (in which case you use VBA code).
See http://www.outlookcode.com/d/comaddins.htm for more information.

Your newsgroup interface isn't posting parts of the preceding message in the
thread, so it's hard to follow things. Please post that manually in the
future.