Sub 数据导出()
Dim i As Integer
Dim sh As Worksheet
For i = 1 To Sheets.Count
If Sheets(i).Name Like "Sheet1*" Then
Sheets(i).Copy
Set sh = ActiveSheet
sh.SaveAs ThisWorkbook.Path & "\" & "2014年" & ".xls"
ActiveWorkbook.Close True
End If
Next
End Sub
请问一下数据导出时如何才能不出现提示是否替换对话框,直接替换