Overwrite option when saving a workbook
 

Upon closing a new workbook, Is there a way to overwrite any other workbook
of the same name in the given folder, without halting the macro to ask the
user?

wbkR.Close SaveChanges:=True, Filename:= "Spreads.xls"


Rgds,

Overwrite option when saving a workbook
 

Bharath,

I think its...

Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = true

HTH
Duncan



Bharath Rajamani wrote:

Upon closing a new workbook, Is there a way to overwrite any other workbook
of the same name in the given folder, without halting the macro to ask the
user?

wbkR.Close SaveChanges:=True, Filename:= "Spreads.xls"


Rgds,