View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Saving an Excel worksheet without getting the confirmation box

I am attempting to update data into a spreadsheet, which I
have declared as an object using the CreateObject()
function. The problem is that I want to write a new row of
data then save, using the existing file name i.e.
overwrite the file, but don't want to confirm this each
time.