改为如下试试: Private Sub CommandButton1_Click() Application.ScreenUpdating = False '关闭屏幕刷新 PH = "D:\" & Application.Text([C2], "yyyymmdd") & ".xls" If Dir(PH) = "" Then ActiveWorkbook.SaveAs Filename:=PH ElseIf MsgBox(Chr(34) & "文件:" & Application.Text([C2], "yyyymmdd") & Chr(34) & "已经存在是否重新保存?", vbYesNo, "提示!") = vbYes Then Application.Dialogs(xlDialogSaveAs).Show End If Application.ScreenUpdating = True '打开屏幕刷新 End Sub
[此贴子已经被作者于2010-5-31 18:02:18编辑过] |