Running an external Macro
You have to open the workbook. The macro is data in a file - Excel
interprets it, makes it executable code and executes the code. To do this,
it has to open the workbook.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
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.
|