Sub 按钮3_Click()
Dim wb, mywb As Workbook
Set mywb = ThisWorkbook
On Error Resume Next
Kill ThisWorkbook.Path & "\" & Month(Date) & "月" & Day(Date) & "日导出工单.xlsx"
Set wb = Workbooks.Add
mywb.Sheets("材料使用").Copy after:=wb.Sheets(1)
mywb.Sheets("工单").Copy after:=wb.Sheets(1)
Application.DisplayAlerts = False
wb.Sheets("sheet1").Delete
wb.Sheets("sheet2").Delete
wb.Sheets("sheet3").Delete
Application.DisplayAlerts = True
wb.SaveAs ThisWorkbook.Path & " \" & Month(Date) & "月" & Day(Date) & "日导出工单.xlsx"
wb.Close
End Sub
å¯è½æ¯ææ²¡è¡¨è¾¾æ¸ æ¥ï¼å½åæ¯XLSMæ ¼å¼çï¼æå¸ææ°å»ºçå·¥ä½ç°¿å¦å为XLSX
当前工作簿是XLSM格式的,我想要的是新建1个工作簿,把当前工作簿中的两个表格复制给新建工作簿,然后保存新建工作簿,但是总是不会自动保存,请教各位看看原因是什么