[算表] 另存檔案關閉後連同excel一起關閉

[ptguitar (佩蒂吉他)]

軟體:excel

版本: 2007

寫了一段vba


ActiveWorkbook.SaveAs "D:\try" & mm & ".xlsx", FileFormat:=xlOpenXMLWorkbook
MsgBox "檔案已另存" & "D:\try & mm & ".xlsx"
ActiveWorkbook.Close True
Application.DisplayAlerts = True
Application.EnableEvents = True
Application.Calculation = xlcalaulationAutomatic
Application.ScreenUpdating = ture
End Sub

關閉檔案後 還是會留著excel視窗

不知道要怎麼連同excel一起通通關閉?


--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 60.250.67.77
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1488769741.A.C94.html
→ soyoso: application.quit
→ ptguitar: 感謝s大 可以了