automatically save changes?

[slim]

Please, what code do I need to put in to make sure that any changes made to a sheet are automatically svaed without throwing up the do you want to save changes box?

I assume within the this workbook part I add a subroutine called sub workbook_close() then put some code in there.

I tried workbook.close savechanges=true but this did not work
savechanges = true on its own did not work either.

Is workbook_close()an acceptable routine, will it run automatically on close or should it be something like autoclose?

Any help much appreciated

Andy

[Sam W]

I'm sure not an expert but you could put a button on the worksheet, name it Exit whatever, go into the button properties and take the check out of print object. Go to the view code on the button and paste in

Private Sub CommandButton1_Click()
ActiveWorkbook.Save
Application.Quit
End Sub

[Paul B]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save
End Sub

[danclemson]

Hi,
try to close all the alters when start excel
excelApp.DisplayAlerts = False

then save your workbook before close it.
sourceWB.SaveAs filePath$
sourceWB.Close

dan