EXCEL/Progress Spreadsheet Question...

b8tovene

New Member
I am calling excel in a progress program and populating cells etc. anyone have the syntax to supress to "Do you want to save your changes" prompt?

As always, thanks for your help.
 
Hi Mark,

Try this:

/* Close workbook without save changes question */
chWorkBook:Close(0,,).

/* Quit Excel */
chExcel:Quit.

/* Release com-handles */
RELEASE OBJECT chWorkbook.
RELEASE OBJECT chExcel.


It worked for me :)

HTH.
 
You can also turn most system prompts off by using the following command:

<com-handle>:DisplayAlerts = true/false.
 
Back
Top