Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macros | Excel Worksheet Functions | |||
Running Macros | Setting up and Configuration of Excel | |||
VBA - Run Macros Remotely? | Excel Programming | |||
HELP: Running two Macros, one before the other | Excel Programming | |||
Running macros | Excel Programming |