N/APosted on - 10/19/2014
I want to add a function in MS Office. Currently I'm looking to develop in VBA. However, it seems that the execution of macros requires security disabled. This means that when I distribute the VBA program, others have to enable macros to run. (Security Issues) The problem now is how do I distribute the VBA I wrote ZB in an EXE And there is another way to go about creating this module?
Adding a feature in MS Word
Dear Grover L Pyne
The simple answer of your question is via add ins. Add ins are used to distribute "Macros".
Add ins creation to distribute Macros:
Now follow the steps below to create and distribute add ins. Add ins are simply Excel workbook (we are taking here excel is an example) which are save with xla extension. To do this simply create a work book and save as and choose "xla" as extension. Once created, workbook can only be viewed in "Project Explorer" via "Visual Basic Editor".
Add ins Distribution:
After following the procedure below other users can easily open / install your add ins .
User should save a copy to C/windows/Application Data/Mircorsoft/AddIns
Open the new work book
Go to tools then add ins then click browse and select the desired file and click ok.
Now make sure that add ins is available and its box is checked.
Now click ok and Add ins will be installed and ready to use.