作者ptguitar (佩蒂吉他)
看板Office
标题[算表] 另存档案关闭後连同excel一起关闭
时间Mon Mar 6 11:08:58 2017
软体: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://webptt.com/cn.aspx?n=bbs/Office/M.1488769741.A.C94.html
1F：→ soyoso: application.quit 03/06 11:14
2F：→ ptguitar: 感谢s大 可以了 03/06 11:34