Link to home
Start Free TrialLog in
Avatar of dougshepard
dougshepard

asked on

Push VBA code out to everyone in my company

Is there a way to push some VBA code out to all of my users (using GP or regestry edits or anything)?

I want to prevent users from sending messages with no subject.  I have some code that does this on my local computer, but I want to push it out to everyone... how can I do this?

Thanks

Doug
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dougshepard
dougshepard

ASKER

I replaced that file but it only "kicks in" if I go into the VBA editor in Outlook on a particular machine.  Any ideas?

Doug
Are you saying that none of the code works unless you are in the VB editor?
I copied the file to someone's computer but it still didn't make them have a subject.  Then I went to their computer and opened the VBA editor in Outlook.  Then I closed it.  From that point on it would no longer allow a blank subject.

At least I think that's what happened...  Seem possible?

Thanks

Doug
Doug,

Yes, it seems possible.  I'm just not seeing any clear reason why.  
Doug,

Any progress?
I haven't had any time to address.  I will try to in the next few days.

Thanks

Doug
Any update, Doug?
My initial post answered the poster's initial question, so I believe I deserve some credit.
From: http://www.outlookcode.com/d/vb.htm

You can copy the VBAProject.otm file to another user's machine but the macros won't run until the user has actually used one of the Tools | Macro commands. See Distributing Microsoft Outlook VBA Code for other thoughts and techniques on distributing VBA macros.

Even though you can copy the VBAProject.otm file, it's still not a supported method for distributing Outlook macros company-wide. The recommended method is to create an Outlook COM add-in.

http://www.outlookcode.com/d/comaddins.htm

Doug
Doug,

A COM add-in isn't VBA code.  COM add-ins are written in VB or C and require much more programming skill than an Outlook macro.  
Right...  I included that just for reference.

I really just wanted to share this: "You can copy the VBAProject.otm file to another user's machine but the macros won't run until the user has actually used one of the Tools | Macro commands."

Since that exact issue is the reason I left this question open for so long...

Thanks

Doug
Got it.  Good point.  Thanks for sharing.