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
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