how to quit excel without saving and suppress the prompt?

I am suing excel application for some intermediate work but don't want to
save the result in excel

Hi,

Set the Saved property of all open Workbooks to True.

--
SvenC

thank you very much,
I guess the key is **all** the work books. I only marked the workbooks I
added

thank you

btw I resort to
oBook.Saved = True ' not needed if xlApp_WorkbookBeforeClose is in
place


oExcel.PromptForSummaryInfo = False
oExcel.Application.DisplayAlerts = False
to avoid being prompting

I suspect I still missed a workbook someplace "the only workbook I can find
is actually in the line
oExcel.Workbooks.Add
but that dos not have the property Saved for oExec.Workbooks.


"SvenC" <SvenC (AT) community (DOT) nospam> wrote