gyugyi@portia.Stanford.EDU (Paul Gyugyi) (09/24/90)
I'm writing a program that responds to DDE_POKE messages, and I'm having a problem communicating with Excel. If I enter a text string into a cell in excel, I can then use the POKE() macro to successfully send that string as the data part of the message. However, if the cell is actually a formula, like =REPLACE(...) that does some fiddling with a string and returns a new one, the excel POKE() macro will send the string "=REPLACE.." instead of the string that the formula returns. Does anyone know how to send a computed string via excel's POKE()? Also, when Excel POKE() the data to me, it sends it in about four different formats before it sends it in CF_TEXT. I keep NAKing the poke message until I get it in CF_TEXT form. On of the formats is CF_SYLK, and the other three aren't documented in the SDK ref manuals. Anyone know what these are? Thanks. Paul Gyugyi gyugyi@rascals.stanford.edu