EXCEL/Progress Spreadsheet Question...

[b8tovene]

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.

 

[jongpau]

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.

 

[cup99]

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

<com-handle>isplayAlerts = true/false.

 

[b8tovene]

Paul, that code did the trick. Thanks