Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Background:
I'm trying to pass arguments to an Excel macro using Dynamic Data Exchange (DDE). I can pass arguments to this Excel macro within Excel (not using DDE) with the following format, note the lack of parenthesis: Application.Run "Personal.xls!MacroName", Arg1, Arg2, Arg3 I can also pass control to this Excel macro using DDE from another Office application (Word) without arguments using the following format (note the presence of parenthesis and brackets): [Application.Run("Personal.xls!MacroName")] However, when including arguments (using the above parenthesis and bracket format) from Word, I get Error Code 4599 "Process failed in other application." Question: How to pass arguments to an Excel macro using Dynamic Data Exchange (DDE)? -- Ted |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to pass variables as arguments of a function | Excel Worksheet Functions | |||
small fuction problem pass arguments | Excel Programming | |||
How to pass arguments to vlookup in VBA | Excel Programming | |||
Run/execute VBS and pass arguments | Excel Programming | |||
How to pass arguments from ThisWorkbook to a UserForm | Excel Programming |