Running an external Macro
How do I get this to work?
Private Sub btnUpdateLifeCycle_Click()
Dim strMacro As String
strMacro = "\\arlfs03\shared\Engineering\ENG\BOM Archive\" & "'" &
"BOM_Macros.xls" & "'" & "!UPDATE_LIFECYCLE_SUMMARY"
Run (strMacro)
End Sub
I want to fire off a macro without having to open and close the
workbook containing the macro.
|