Disable Excel Save

[MechEngCoder]

Hi,

I have an application where I import some data from an excel file to a database, to assist the alogrithm and speed I use the sort method on the worksheet. Everything works fine but when the app calls excel.application.quit it displays a dialog asking user if the changes are to be saved (the result of the sort).

This app is to run as a service and hence can not require user input to run. I have tried setting the DisplayAlerts of the excel.application object to false and setting the workbook object saved property to true before the call to the excel application objects quit method with no luck, the dialog still displays. I am using Excel 2000 SP3 with VB 6. Any ideas on what else I can try to get rid of this dialog?

Thanks in advance.

MechEngCoder

[MartinLiss]

Have you tried

oXL.Workbooks(1).Close SaveChanges:=False

[MechEngCoder]

Worked, Thanks