Help! Please Help,Gary!!!!

[Herbie1809]

Hi Gary,

I don't doubt you're very busy, but I'm completely stumped on this one...

Here's the set up:

I have two pages open in BA, both connected to the same race.

In Excel, I have two worksheets in the same workbook. Sheet1 is connected to Page 1 in BA, and places lay bets. Sheet 2 is connected to Page 2 in BA, placing back bets-its a long story.....

But each time I've set this up before leaving for work, I've come home to fiind Excel(2003) has encountered an error and no bets have been fired.

I've attached the Excel error log below. Any ideas??


11:28:40 Getting selection range* System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Betting_Assistant.Excel.getXLRange(String r1, String r2, String action, Object ws)
11:28:50 Getting selection range* System.Runtime.InteropServices.COMException (0x8001010A): The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at

07:17:38:132: Excel not updated. Requesting bets refresh. Last bets refreshed market does not match current market.
07:17:52:110: Requesting Excel refresh. Origin cell:A1
07:17:52:765: Excel update skipped. First update after market changed.
07:17:53:124: Requesting Excel refresh. Origin cell:A1
07:17:53:264: Excel updated.
07:17:54:138: Requesting Excel refresh. Origin cell:A1
07:17:54:200: Refresh rate changed by Excel trigger from 1 to 10 (Sthl 21st Dec - 12:35 5f Hcap)
07:17:54:200: setRefreshRate invokeBegin
07:17:54:247: setRefreshRate invokeEnd
07:17:54:263: Excel updated.
07:18:04:309: Requesting Excel refresh. Origin cell:A1

[GaryRussell]

Those errors are normal. The important thing is the log says "Excel updated" regularly which means it is updating Excel and reading the triggers successfully.

Also those errors are from the logs in BA. Are you saying Excel itself is displaying an error message saying it has encountered an error? It's unlikely that BA caused Excel to crash in this way. You could try re-installing office if this is happening.

[Herbie1809]

Cheers,mate.


Sort of got round the problem by using two separate workbooks.

Onwards and upwards, I'm still learning.