Running a macro from another workbook

Hi guys,

I am trying to create a macro that opens certain workbooks and triggers a macro to run, but I am having some problems.

I have written the below code. Which I though would work but no joy...


_____________________________________

Sub OpenAndRun ()

Workbooks.Open ("FilePath and FileName.xlsm")
Application.Run ("'FilePath and FileName.xlsm'!MacroName")

End Sub
______________________________________




The file opens as expected, but the macro will not run. Instead I get the below error message.



________________________________
Run-time error '1004':
Cannot run the macro 'FilePath and Macro Name'.
The macro may not be available in this workbook or all macros may be disabled.
________________________________





Please help!!