Triger macro on and of a file on diff. machine

  • Thread starter Thread starter Kash
  • Start date Start date
K

Kash

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

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

If this post helps click Yes
 
The above works only if the macro file is opened in the same machine..

If this post helps click Yes
 
So, is there a way to run a macro from a sheet opened on a different machine
which are in the same network?
 
Back
Top