Saving Workbook

[DaveUK]

I need to save the Open workbook and overwrite the existing one without any message about overwriting.

I want to keep all the changes made.

The Workbook is called "Weekly Surveys".

I know i need to use:


Application.EnableEvents = False
'
' NOT SURE WHAT CODE TO USE
'
Application.EnableEvents = False
Application.quit

Please could someone tell me the code to use.

TIA

 

[CraigM]

It's the DisplayAlerts property you want to set to false, not the EnableEvents property (unless of course there is a BeforeSave event that you are trying to avoid running).

Eg:

Application.DisplayAlerts = False
ThisWorkbook.SaveAs ("C:\Weekly Surveys.xls") 'Change path to suit
Application.DisplayAlerts = True

 

[DaveUK]

Hehe,

Silly me i haven't a clue why i typed that instead of DisplayAlerts.

lol

Many thanks for your help.