Calling Macro in another workbook

[Gregorys05]

When calling a macro in another workbook via a active x command button I am getting a;

Run time error 1004 - cannot run the macro "macroname". The macro may not be available in this workbook or all macros may be disabled.

Here is what i am trying to run.
Workbook = AWD BI - Amendment Turnaround & Error Type Analysis v14.xls
Sheet Macro is on = DEALAMEND MI Summary
Macro name = Refresh

Application.Run "'AWD BI - Amendment Turnaround & Error Type Analysis v14.xls'!DEALAMEND MI Summary.Refresh"

Any ideas what i am doing wrong.

Thanks

 

[Andrew Poulsom]

Use the Worksheet's CodeName, eg:

Application.Run "'AWD BI - Amendment Turnaround & Error Type Analysis v14.xls'!Sheet1.Refresh"