Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the best means available from within the MS Office 2010 suite to package up macro code written for Outlook, so that I can make it available to my coworkers and make it easy for them to install and use? We have shared drive space on a network, so passing code files back and forth shouldn't be a problem.

share|improve this question
Do you need to package up a rule set too, or just the VBA code? I mean, you can always store the code in a txt file, right? – allquixotic Aug 20 '12 at 22:30
I could send them just a text file and have them put the code in a new module. But they would need to learn roughly how the VBA IDE works, and I'd have to show them how to create their own digital signature to run the code. That's a pretty tall order. So ideally, I'd like them to be able to import my module, accept my own signature, and then find the macro so they can run it. No need to hide the code, I just want them to be able to use it as quickly as possible. – eksortso Aug 21 '12 at 16:41
Various options: – Jüri Ruut Dec 22 '12 at 16:43
up vote 1 down vote accepted

The easiest way would be to go into the visual basic editor and press CTRL + E to export the module.

Then place it on the share and others can go into visual basic editor and press CTRL + M to import the module.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .