DDL and EXCEL (None Specified)
At 08 NOV 1999 08:14:56AM Debbie Cornett wrote:
I have an DDL application stuffing an EXCEL spreedsheet. Is there any way to issue a command from within OI that will take EXCEL down when I am done. I don't want the user to have to close EXCEL manually.
Thanks!
Debbie
At 08 NOV 1999 11:37AM Rob Misek wrote:
Debbie–
I believe that you can use the DDECOMMAND property to force a close of EXCEL.Ex:
x=Set_Property(DDE_info,'DDECOMMAND','File.close()')Other EXCEL commands would be:
Action Command
Close the Spreadsheet QUIT
Print the Spreadsheet FILEPRINT
Save the Spreadsheet FILESAVE
Exit the Spreadsheet FILEEXIT
Rob
Revelation
At 08 NOV 1999 04:11PM Mike Ruane wrote:
Rob-
This looks familiar to me…..
At 08 NOV 1999 04:22PM Debbie Cornett wrote:
Rob,
I am almost there, but not quite. The HERE link at the start of this thread still doesn't work for me. In addition, I am not sure of the exact syntax to Save the worksheet and Close EXCEL. I can get EXCEL to close automatically, but I still must manually specify that I want to save the worksheet. Can't that be done automatically? Thanks! Debbie
At 08 NOV 1999 04:59PM Rob Misek wrote:
Debbie–
Here is the code that you requested via phone:status=Set_Property (@WINDOW:'.DDE_INFO','DDECOMMAND','SAVE')
status=Set_Property (@WINDOW:'.DDE_INFO','DDECOMMAND','QUIT')
If you do not save prior to the quit command Excel will wait for you to confirm the save.
Rob
Revelation
At 08 NOV 1999 05:01PM Rob Misek wrote:
Mike–
Always learn from the master...
At 08 NOV 1999 05:04PM Debbie Cornett wrote:
Works perfectly! Thanks a bunch.