假设把工作表名为sheet2另存到D:\ Sub Macro1()
Dim mypath As
String
'''''''''''这部分,因你的情况不具体,所以需修改 mypath = "d:\" mypath = mypath & Month(Date) & "月XX表.xls" Sheets("Sheet2").Copy ''''''''''''''''''''''''''''''''''''''''''''''' Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=mypath, FileFormat:=xlExcel8 Application.DisplayAlerts = True ActiveWorkbook.Close End
Sub
[em09] |