Run a macro in a workbook through VB6

  • Thread starter Thread starter Eric Marple
  • Start date Start date
E

Eric Marple

What is the proper syntax to run a macro which has
parameters in a specified workbook?
 
hi,
If the macro is in the current WB then
tools>Macros>macro>run should do it. you will be prompted
of the perameters.
If the macro is to be run on another WB then code must be
add to open the other workbook.
ChDir "C:\dir1"
Workbooks.Open Filename:="C:\Dir1\file2.xls"
or if open to activate the file.
Windows("file2.xls").Activate
 
Actually I need to run a macro in a specific workbook
throufh a VB.exe I wrote. The excel workbook is never
visible. How do I run a function that takes parameters in
a workbook through VB6?
 
Hi Eric,
What is the proper syntax to run a macro which has
parameters in a specified workbook?
Click to expand...

From VB:

xlApp.Run "WorkbookName.xls!RoutineName", arg1, arg2

where xlApp is a variable referencing the Excel Application object.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 
Check the Application object's Run method.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
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

VBA to VB6 6
Run code from another workbook 7
Macro shortcuts are running macros in different open workbook 3
Run Macro If Cell have "x" value 0
Opening a list of Excel files and run a macro in each 17
VBA Debug Issue 2
Unwanted workbooks on startup 2
Macro for all Excel Workbooks to print to PDF 2

Back
Top