What's the best way to distribute VBA macros?

[Alan]

Hello,

We have developed a few in-house VBA macros for Outlook to help out
users. Any suggestions please on the best way to package and
distribute them to end-users? We have a few thousand.

By "best" I mean reliable and requiring the least user-interaction
possible...!

(Also, anyone got a link to a "CDO for dummies"-type website or even
better book please?)

Thanks,

- Alan.

 

[Ken Slovak - [MVP - Outlook]]

There is no good, maintainable way of distributing macros or Outlook VBA.
The preferred solution is to put the code in a COM addin and deploy that.
See the section on VBAProject.OTM for more information, and specifically see
http://www.outlookcode.com/d/distributevba.htm.

The definitive Web site for CDO 1.21 information is www.cdolive.com. Code
snippets are at www.cdolive.com/cdo5.htm and undocumented property tags are
at www.cdolive.com/cdo10.htm. There are also downloadable projects. Note
that the site hasn't been updated in years however and that Sig Weber no
longer owns it or does CDO work.

The only book I know of that has any depth at all is Professional
Programming CDO, by Sig Weber and Dan Mitchell, et al. It's out of print but
you can probably find it at Amazon. It was published by Wrox Press before it
became owned by Wiley. Some Outlook programming cover CDO in a small way,
like Randy Byrne's and mine but not with the depth of Sig and Dan's book.