excel vba‎ > ‎

VBA - run macro on the active workbook

posted May 18, 2011, 1:00 AM by Roberto Felicini   [ updated May 18, 2011, 2:34 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"
Comments