Running & maintaining macros remotely

[Fanatik]

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

 

[Jim Rech]

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
| 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