Running & maintaining macros remotely
Hi
I'm new to VBA, but learning fast with the help of the newsgroup. The problem I have is that as my knowledge gets better, the macros I have written are improved, however it is not practical to install the improved macros on to all users' machines due to them being located all over the country and their limited understanding of Excel preventing them importing them. So I was wondering if someone could tell me whether it is possible (and if it is how) to enable it so that when users run a macro, instead of running the macro installed it goes to a specified shared directory and runs the VB file contained within it. That way any improvements I make will be available to all users. Many thanks in advance |
Running & maintaining macros remotely
You can certainly write a macro that opens a workbook (read only) on a
universally accessible server and then uses the Run method to execute a macro in it. -- Jim "Fanatik" wrote in message ... | Hi | | I'm new to VBA, but learning fast with the help of the newsgroup. | | The problem I have is that as my knowledge gets better, the macros I have | written are improved, however it is not practical to install the improved | macros on to all users' machines due to them being located all over the | country and their limited understanding of Excel preventing them importing | them. | | So I was wondering if someone could tell me whether it is possible (and if | it is how) to enable it so that when users run a macro, instead of running | the macro installed it goes to a specified shared directory and runs the VB | file contained within it. That way any improvements I make will be available | to all users. | | Many thanks in advance |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com