I want to execute a macro called "Main" held in second workbook from macro in current workbook
current workbook code snippet is as follows:
Dim second_wb As Workbook
Set second_wb = ActiveWorkbook
Application.Run second_wb.Name & "!Main"
I get a "run-time error 1004: The macro 'second macro.xls!Main' cannot be found".
Any ideas anyone please?