Rafael,
If you want to save the file automatically then

oBook.SaveAs(<<XLFile>>)
or 
oBook.Save() if you have saved it already under a name 

then 

oExcel.Quit



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Rafael Copquin
Sent: 24 August 2007 16:50
To: [email protected]
Subject: quit in Excel automation

Hi all

I am reading an Excel sheet using automation.

When I send the command

   oExcel.quit

Excel asks the question of whether I want to save the changes to the sheet.

This is an annoying question, since I want the sheet closing and the excel
quitting to be completely automatic without user intervention.

What is the Excel command I should send to avoid this question?

TIA

Rafael Copquin



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to