Run Time 1004 error when calling sub from another macro

[Curben]

I am tryingto run a macro existing in another workbook opened by a variable, I am using the following code to try and get it to work but i get Run-time error '1004':

Cannot run the macro "Test 5.xlsm'!UpdTables'. The macro may not be available or all macros may be disabled.

Application.Run "'" & Application.ActiveWorkbook.Name & "'!UpdTables"

 

[ZVI]

What I don't understand is why this style works in another Workbook but not in this one?

If name of workbook includes some special characters like space symbol then single quotes in referencing are required.
Using of single quotes in a code avoids problems in referencing to workbook's name, even if they are extra.