Running an external Macro

  • Thread starter Thread starter brittonsm
  • Start date Start date
B

brittonsm

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data to Excel from Access for Analysis 1
Passing string as macro parameter 1
Run Excel macro with arguments from Access 3
run an Excel macro from Access : Run time error 1004 2
Macro in one location and file to run the macro in another locatio 1
Call Macro from another WorkBook? 6
Referencing a public variable in excel from access 2
run-time error 1004 when trying to open an excel spreadsheet from access 1

Back
Top