Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro in Excel that calls a macro in a Word document with this code:
wordApp.Visible = True wordApp.Activate wordApp.Run ("myMacro") But when I changed the Word macro to require parameters, using the following code, I get Run-time error '-2147352573 (80020003)' Unable to run the specified macro: wordApp.Visible = True wordApp.Activate wordApp.Run ("myMacro", 'String with spaces', numVal1, numVal2) So I tried using the following code, but I get Object doesn't support this property or method: wordApp.Visible = True wordApp.Activate result = wordApp.Run ("myMacro", 'String with spaces', numVal1, numVal2) What code should I be using? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
How To Call VBA Code from Excel 4 Macro | Excel Programming | |||
call .DOC from an Excel VBA macro ? | Excel Programming |