Sub sheet另存为工作簿()
Sheets(Array("人员档案", "明细一", "明细二", "明细三")).Copy
Workbooks(Workbooks.Count).SaveAs ThisWorkbook.Path & "/" & "数据备份.xls"
End Sub
VBA另存指定工作表并改名
最新推荐文章于 2024-04-29 20:21:42 发布
Sub sheet另存为工作簿()
Sheets(Array("人员档案", "明细一", "明细二", "明细三")).Copy
Workbooks(Workbooks.Count).SaveAs ThisWorkbook.Path & "/" & "数据备份.xls"
End Sub