VBA - run macro on the active workbook

Post date: May 18, 2011 8:00:07 AM

Sub run_macro()

wrk = ActiveWorkbook.Name

Application.Run ("'" & wrk & "'" & "!test")

End Sub

OR fixed name

'Application.Run "'ECI - OFF TAKE MANAGEMENT.xls'!upg_salesreport"