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
|