sharing macros

[Guest]

I wrote a small macro that I would like to have other people in the office
use. I read some articles one of which said you can copy the project but it
has some known bugs. We also came up with being able to export the module
and importing on another users machine. This seems to work fine.

I just wanted to know if there is a better way to handle this and if a com
add-in (which I know nothing about) is the way to go, would there be code
already written for doing this.

I do have the project signed, if that makes a difference.

Any and all insight will be greatly appreciated.

Thanks.

 

[Ken Slovak - [MVP - Outlook]]

Distributing VBA projects is discouraged, not that it's buggy but it
overwrites any macros the user has. Signed projects would need to have the
signature installed on the user machine.

For a simple macro trading the code module around is probably the easiest
way.

COM addins are the most robust solution for wider distribution but they are
more complex to develop and require a development platform outside of VBA.