Sharing macros

R

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
 
K

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.
 
K

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.
 
Top