Should I create an addin? 1

[thomasks]

I have an outlook macro written that creates tasks from emails, that is used by several of my coworkers in the office. Recently one of the geniuses in IT "ghosted" a coworkers machine and reinstalled Microsoft Office.
He lost all the code for the macros that was there. I had to cut and paste the code back in from an email for him, to fix it.
My question is, should I create an add in for this code? And how do I do that if it was written in VBA?

 

[rmikesmith]

The only type of Add-In available in MS Outlook is a COM Add-In, which cannot be implemented using VBA (although it can be done in VB 6). If you want to explore that avenue, here is a helpful webpage:

http://www.outlookcode.com/article.aspx?id=36

Regards,
Mike

 

[ClulessChris]

You could have copied the *.OTM file from yours to his profile. This is the outlook project file where all the VBA code is held.

Everybody is somebodys Nutter.

 

[rmikesmith]

One caveat with distributing the VbaProject.otm file is the potential to delete/disable an end user's own custom code. If the .otm file already exists, you're back to copying & pasting the new code.


Regards,
Mike

 

[ClulessChris]

Good catch Mike I forgat to mention that, have a star.

Everybody is somebodys Nutter.

 

[rmikesmith]

Thanks, Chris.

Having mentioned that possibility, I will say that I have used just that technique. I was reasonably certain it wasn't an issue (new pc's recently deployed) and my install program checked for existing *.otm file and renamed if found. Not ideal but sufficient in this case.


Regards,
Mike