Path: utzoo!censor!geac!torsqnt!hybrid!scifi!bywater!uunet!world!goodearl
From: goodearl@world.std.com (Robert Goodearl)
Newsgroups: comp.windows.ms.programmer
Subject: Re: DDE Questions/Information, please...
Message-ID: <1991Jan13.063448.16008@world.std.com>
Date: 13 Jan 91 06:34:48 GMT
References: <17497@brahms.udel.edu> <908@ehviea.ine.philips.nl> <17539@brahms.udel.edu>
Organization: The World @ Software Tool & Die
Lines: 35

In article <17539@brahms.udel.edu> garrett@brahms.udel.edu (Joel Garrett) writes:

...

>  I am assuming that you
>can work with a range of cells by using the same range notation that you would
>use in a worksheet formula, ie a1..a7 or the like...

I'm not sure if there are multiple notations that it will accept, but I know
that you can use Row Column addressing.  ie: R1C1 or R2C4:R3C5

>  There is absolutely no mention of DDE in
>either the online or printed docs for the Windows version of Wingz.

The SDK sample client app can enumerate all the available DDE servers.  A good
indication of Wingz support for DDE would be to start it up, run the SDK
client app and enumerate the servers.  If it supports DDE it should show up
in the list.

>
>Is there an easy way to send commands to Excel (ie multiply all cells by
>some value and then add another value to each and then return the result via
>dde?)
>

No easier than doing the same operation from within the spreadsheet.
Generally the easiest way to send data to Excel is to use the WM_DDE_POKE
message from your client app.  Then you could use the WM_DDE_EXECUTE message
to tell excel to execute the macro which causes your required operations to
happen.  If you want to get fancy, you could POKE the macro(s) and then
EXECUTE.  Finally you use WM_DDE_REQUEST to get the data back.


-- 
Bob Goodearl -- goodearl@world.std.com