AnsweredAssumed Answered

VRF-Command syntax for DDE execute transactions

Question asked by VRFuser on Jun 23, 1999
Does anyone know where I could get a list of proper syntax to use for
DDE execute transactions for Excel spreadsheets?  Two examples are:

EXECUTE CMND:"[SAVE.AS("filename.xls")]"
EXECUTE CMND:"[FORMULA("=PMT(r1c1/12,r1c2*12,r1c3)","r1c4")]"

The tools-customize-commands menu in Excel kind of gives you some ideas
about what is available but lacks what I need for programming.

In particular, I would like to insert X rows into the spreadsheet so
that rather
than incrementing the row numbers for my r1c1:r12c20 write statement on
each
run, I can simply bump the data down and keep writing to the same
location.

Thanks for your thoughts!

Jon Craig


Outcomes