CORRECT SYNTAX FOR RUN...

Hi,

I've been trying to solve this problem for a few days now. What is the
correct
syntax for Run, when executing a sub procedure in a DIFFERENT workbook
under the following conditions: the procedure has arguments, and you
are passing the code to run the macro with its arguments as 1 string:

sub RunMacro(STRING)

Application. Run STRING

End Sub

Where STRING has a value like "FILE.XLS!MACRO ARG1, ARG2"

Thanks for any help you can give

Regards,

Ian

Ian, i'm not entirely sure what it is your trying to do if all you want to do is run a macro you just call it like Call RunMacro. I created a macro called Test1 and put this line in the Worksheet SelectionChange event (just cos i'm lazy) Application.Run ("Test1"), so when i selected a new cell it run the macro.....it worked fine.

Regards,
Simon

Perhaps something like this?

Application.Workbooks.Open ("C:\Documents and Settings\Simon\Desktop\test.xls")
With Workbooks("test.xls")
Application.Run ("Macro1")
End With