Forum Discussion
Macro Code on Server
Hello everybody,
I'd like to know if it is possible to keep macro code on a server, so only updating the code on server will change behaviour for all excels that imported the code on server?
The macro I wrote will be used by many users, so in case of any bugs or change requests, it will be much easier to update one source and let the others read from that source.
Thanks.
I'd like to know if it is possible to keep macro code on a server, so only updating the code on server will change behaviour for all excels that imported the code on server?
The macro I wrote will be used by many users, so in case of any bugs or change requests, it will be much easier to update one source and let the others read from that source.
Thanks.
- Just having the code somewhere remote is hard because you will have to change a security setting to allow changing VBA code with VBA code (Allow Access to VBA Project Object Model), which is a pain. Easier is to move your code to an add-in and make sure you can easliy replace the add-in.
One way: Save the add-in to a server location, right-click the file, select Properties and check the Read-only box. That way you can simply replace the file when you have updated the code (do not forget to set to read-only again!).
Another way: http://www.jkp-ads.com/Articles/updateAnAddin.asp
