View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
 
Posts: 41
Default 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,