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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you saying that none of the code works unless you are in the VB editor?
ASKER
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
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.
Yes, it seems possible. I'm just not seeing any clear reason why.
Doug,
Any progress?
Any progress?
ASKER
I haven't had any time to address. I will try to in the next few days.
Thanks
Doug
Thanks
Doug
Any update, Doug?
My initial post answered the poster's initial question, so I believe I deserve some credit.
ASKER
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
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.
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.
ASKER
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
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.
ASKER
Doug