Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!wuarchive!udel!brahms.udel.edu!garrett
From: garrett@brahms.udel.edu (Joel Garrett)
Newsgroups: comp.windows.ms.programmer
Subject: Running Excel via a DDE link... (How can I?)
Message-ID: <20187@brahms.udel.edu>
Date: 4 Apr 91 13:51:03 GMT
Organization: University of Delaware
Lines: 24

I would like to be able to activate a series of excel macros from within anothe
program via a DDE link.  An example of such a transaction would be like so:

* my program prepares some data (a nxm array)

* excel is started and loads a spreadsheet with macros in it, via a DDE request
  to excel, requesting data from a cell which contains a macro in it which will
  open a new worksheet to hold the incoming data and then returns the name of
  that sheet over the DDE link.

* my program sends the array of numbers to the new worksheet. (actually two
  steps, right? Send data, then execute a macro to do a 'paste link' into the
  empty worksheet, is this correct?)

* my program activates a macro which will perform a set of transformations or
  some other operation on the data.

Is this level of interaction possible without getting the user involved in
things?

						Thanks,
						Joel

						garrett@brahms.udel.edu