| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't create ini file on a Vista machine | Excel Programming | |||
| Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
| Corrupted Excel file - but on only one machine? | Excel Programming | |||
| Need to triger an event | Excel Programming | |||
| file transfer to/from a unix machine | Excel Programming | |||
Linear Mode
