admin管理员组

文章数量:1123049

I have a VBA macro to refresh all data connections in the excel file. This runs fine with no errors. When I run the script below through task scheduler the status gets stuck at running and does not end. Why is it getting stuck/not completing?

Dim xlApp, xlBook
Set xlApp = CreateObject("Excel.Application")

xlApp.DisplayAlerts = False

Set xlBook = xlApp.Workbooks.Open("Z:\FileToRefresh.xlsm", , False)

xlApp.Run "RefreshData"

Do While xlApp.CalculationState <> 0
    DoEvents
Loop

xlBook.Save
xlBook.Close
xlApp.Quit

Set xlBook = Nothing
Set xlApp = Nothing

本文标签： vbscriptTask Scheduler Excel refresh stuck on runningStack Overflow

版权声明：本文标题：vbscript - Task Scheduler Excel refresh stuck on running - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736542973a1944409.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。