Using Application.Run in Excel VBA when workbook name contains spaces

Question

Hello,

Application.Run "MyWorkBook.xls!Macro1"

will work (run the macro called Macro1 in the MyWorkBook.xls file)

Application.Run "My Work Book.xls!Macro1"

will not (if the workbook name contains spaces, Excel says "the macro cannot be found").

I just spent hours figuring out that it's the spaces causing this problem...

Is there a way around this without renaming the file?

Answer 1

Use single quotes surrounding the filename:

Application.Run "'My Work Book.xls'!Macro1"