View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brittonsm@verizon.net is offline
external usenet poster
 
Posts: 2
Default 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.