Hi All,
I am working on a wallboard via VBA / Excel and Avaya.
The environment:
- We log in the Avaya CMS Application while running the macro
- We run/export 3 reports
- 2 Realtime Reports
- 1 Realtime Reports
The issue is we keep getting the "awaiting another OLE application error.." when it gets to
Code:
b = cvsSrv.Reports.CreateReport(Info, Rep)
If b Then
DoEvents
Rep.Timeout = 10
Rep.FastLoad = True
Rep.Window.Hide
Rep.Window.Top = 500 - 1000
Rep.Window.Left = 500 - 1000
Rep.Window.Width = 0.5
Rep.Window.Height = 0.5
Rep.TimeZone = "default"
Rep.SetProperty "Agent Group", sk
Rep.SetProperty "Refresh Every", "30"
b = Rep.ExportData(expath & expNme, 9, 0, False, True, True)
Especially when it gets to
Code:
b = Rep.ExportData(expath & expNme, 9, 0, False, True, True)
I've watched the Task manager and there's only one instance of anything "acsXXX.exe"
So the only reason I can come up with for the OLE error is that it takes too logn to export the data from CMS.
How does one, skip the specific report export if it takes too long? If not, how does one properly debug the OLE error?
Thank you,
Holly