Triger macro on and of a file on diff. machine
 

Hi, Say I have 5 files in a shared folder which are linked to master.xls and
these files are opened on different machines. Can I some how make a macro
which is on these files to run from master.xls?

Triger macro on and of a file on diff. machine
 

Try

Application.Run ("'excelfilename.xls'!macroname")

If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

Hi, Say I have 5 files in a shared folder which are linked to master.xls and
these files are opened on different machines. Can I some how make a macro
which is on these files to run from master.xls?

Triger macro on and of a file on diff. machine
 

The above works only if the macro file is opened in the same machine..

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

Application.Run ("'excelfilename.xls'!macroname")

If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

Hi, Say I have 5 files in a shared folder which are linked to master.xls and
these files are opened on different machines. Can I some how make a macro
which is on these files to run from master.xls?

Triger macro on and of a file on diff. machine
 

So, is there a way to run a macro from a sheet opened on a different machine
which are in the same network?

Triger macro on and of a file on diff. machine
 

From excel VBA no..
--
If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

So, is there a way to run a macro from a sheet opened on a different machine
which are in the same network?