Log in

View Full Version : Deploying VBA on the domain



ahassan99
09-17-2012, 04:17 AM
Hello,

I have a code that I need to deploy on all the computers on the network. Can a VBScript be written for this?

Also, I need to set the macro settings to ENABLED for all the computers?

How this can be achieved?

JP2112
09-17-2012, 10:31 AM
Hello,

I have a code that I need to deploy on all the computers on the network. Can a VBScript be written for this?

If this is for Outlook, please see http://msdn.microsoft.com/en-us/library/cc513842(v=office.12).aspx

The Outlook VBA environment is really intended for personal productivity macros. It isn't like Excel where you can create addins and distribute self-contained code packages to multiple users. At best, Outlook VBA is cut and pasted into individual projects, one project at a time. The best way to distribute Outlook code (other than code snippets) is through addins.


I need to set the macro settings to ENABLED for all the computers

Not programmatically. This is something each user has to do on their own.