7,763
社区成员
发帖
与我相关
我的任务
分享
Set wbs = createobject("WScript.Shell")
wbs.Run "cscript killExcel.vbs ",0,false 'killExcel.vbs就是我写的sub vbs
Set xlsApp = createobject("excel.application")
With xlsApp
.DisplayAlerts = False
.EnableEvents = False ' 禁止宏自启动(事件停止).Interactive = False
.workbooks.open "c:\a.xlsm"
.Visible = False
On Error Resume Next
.run "a.xlsm!test" '执行vba
.EnableEvents = True
On Error Resume Next
.workbooks.Close
.DisplayAlerts = True
End With
Set xlsApp = Nothing
timeLimitInMins = 1
wscript.sleep timeLimitInMins*60*1000
Call Close_Process()
Sub Close_Process()
On Error Resume Next
For Each Process In GetObject("winmgmts:").ExecQuery("select * from Win32_Process where name='EXCEL.EXE'")
Process.Terminate (0)
Next
End Sub