How do I call an excel macro from outside the workbook?

K

Kenji

I have an excel workbook that opens another excel workbook. I would like to
run a macro in the other workbook.. so far I have

public oexcel as new Excel.Application
oExcel.Workbooks.Open("newstuff.xls")

how can I run a macro within newstuff.xls?
Thanks!

Kenji
 
H

Harlan Grove

Kenji said:
I have an excel workbook that opens another excel workbook.
I would like to run a macro in the other workbook.. so far
I have

public oexcel as new Excel.Application
oExcel.Workbooks.Open("newstuff.xls")

how can I run a macro within newstuff.xls?
Click to expand...

Application.Run "newstuff.xls!YourMacroNameHere"
 

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

trying to email workbook from VB6, getting error 1004 2
macro to call other macros 1
How can I call a Excel Macro from VB? 1
Function or Sub? 9
Excel Macro 7
copy data from one excel workbook to another workbook using macro 4
Excel 2007 - worksheets macro 1
Open Excel from access - Compile Error 2

Top