Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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? –  ÃŁŁǫǛȉЖΦΤїҪ 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
2  
Various options: outlookcode.com/article.aspx?id=28 –  Jüri Ruut Dec 22 '12 at 16:43
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.