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.
Cannot run the macro "Test 5.xlsm'!UpdTables'. The macro may not be available or all macros may be disabled.
Code:
Application.Run "'" & Application.ActiveWorkbook.Name & "'!UpdTables"