That did it ! Thank you
----- Original Message ----- From: Peter Cushing To: [EMAIL PROTECTED] Sent: Friday, August 24, 2007 12:55 PM Subject: Re: quit in Excel automation Rafael Copquin wrote: > 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? > Try: oExcel.displayalerts=.f. Peter [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.