Triger macro on and of a file on diff. machine

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

Jacob Skaria

Try

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

If this post helps click Yes
 
J

Jacob Skaria

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

If this post helps click Yes
 
K

Kash

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Macro to paste value to a file same as A1 10
Create a dynamic master file 1
Setting column width in a table with a macro is not working 0
Menu Macro Not Executing - Need Help 1
File Not Found Msg Because Sheet is Missing ? 3
Automation of scanned file storage based on content 0
Macro to Update links on a network 4

Top