感谢@AlexK.原来是在错误位置的逗号.

Thanks to @AlexK. Turned out to be a comma in the wrong place.

还要感谢此帖子已更改:

 xlApp.Run "Module1.MyMacro"

收件人:

   xlApp.Run xlBook.name & "!Module1.MyMacro"