AnsweredAssumed Answered

VRf: DDE using Excel

Question asked by VRFuser on May 20, 1997
Has anyone successfully been able to quit Excel using a VEE DDE without error? The transaction I am using is (when the topic is set to SYSTEM):

EXECUTE CMND:"[QUIT()]"

Although I use the Microsoft Excel Function Reference, there is much trial and error on my part. I have got the following to work correctly and without error:

EXECUTE CMND:"[PRINT("1")]"
Prints the current worksheet, default everything else

EXECUTE CMND:"[CLOSE("=FALSE")]"
Closes the current workbook, no save (discards worksheet changes)

I would appreciate anyone sharing their experience in using DDE under VEE

Thanking you,

Michael Kolos
ADI Technology Group

Outcomes