thank you ----- Original Message ----- From: Dave Crozier To: [EMAIL PROTECTED] Sent: Friday, August 24, 2007 1:03 PM Subject: RE: quit in Excel automation
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.
