With CommonDialog1
.InitDir = CurDir
.Filter = "所有文件(*.*)|*.*"
.DialogTitle = "另存为"
.ShowSave
If Dir(.FileName) <> "" Then
Dim IsReplace As Integer IsReplace = MsgBox(.FileTitle + "已经存在,覆盖它吗?", vbYesNo, "警告")
'相应的处理代码
End If
End With