Try it without the brackets
I use the following line of code to run a macro in another
workbook.

Application.Run "ACM_Excel_Interface.xls!
UpdateCallerList", ThisWorkbook.Name

so passing the calling workbook's name to the
UpdateCallerList procedure. No value is returned.

Kevin Beckham

-----Original Message-----
I have been using the Application.Run method for a long
time, and
thought I was familiar with its syntax, namely :

Application.Run AnotherSub
Application.Run ("Add-In Name!Macro Name")
Application.Run "'Some book.xls'!TheMacro"

However, I need to pass some arguments to another
procedure, and the
only way I can get it to work is as follows (transferring
a string
variable from the 1st sub to the called sub) :

Application.Run "AnotherSub", My_Procedure_Name

It fails if I try what I expected, ie with the ( )

Application.Run ("AnotherSub", My_Procedure_Name)

But works if I use

Result = Application.Run ("AnotherSub ",
My_Procedure_Name)

Now this isn't too important (hey, it works after I spent
a lot of
time experimenting and searching the Goggle Groups), but
am I missing
something? The Excel help indicates that the ( ) are
required.

Any comments would be welcome in order to broaden my mind!

Regards,

Mark
.