View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Saving Workbook Error-Plz help

I have the following code to automatically save the workbook

Private Sub CommandButton3_Click()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub

I get this mesage box:
"A file named "myfilename.xls" already exists in this location, do you want
to replace it?"
I dont want this to come up. is there any way around this? Thanks