Sub CreWBK(ByVal Sht As Worksheet, ByVal WbkName As String)
On Error Resume Next
Sht.Copy
ActiveWorkbook.SaveAs WbkName
ActiveWorkbook.Close True
End Sub
给上面的过程传递2个变量,就可以满足你的要求。
Sht--------工作表,如:sheets(1)/sheets("sheet1")/sheet1
WbkName----工作簿的保存路径及名称,如:F:\1234.xls