View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ted Ted is offline
external usenet poster
 
Posts: 48
Default How to pass arguments to an Excel macro using Dynamic Data Exchang

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