by Deestar » Mon Sep 28, 2020 12:24 am
So I've taken the plunge with this and I'm instantly regretting it.
I've upgraded to Excel 365. All my excel documents are saved on the local drive and I have ensured that all files are saved to the local computer by default. I'm encountering the following errors.
When I log multiple sheets using the quick link they load as per normal (albeit more slowly than before). There are several errors getting written to the diagnostic log (see below) and one to Unhandled_Exception file.
If I manually try and add a new page (as I routinely do/did) and then try and link it to one of the open workbooks in the Workbook name drop down list only the first workbook shows. (I have 8 open) Previously using Excel 2010 I could selected any of the open workbooks and link a new sheet manually to one of the sheets within it.
Thanks in advance for your help
28092020 00:13:40:947: Application version:1.3.0.47a
28092020 00:13:40:947: Adding news page
28092020 00:13:41:275: News tab page added.
28092020 00:13:41:635: Sending authentication to order stream.
28092020 00:13:41:635: {"op":"connection","connectionId":"103-270920231341-798942"}
28092020 00:13:41:681: {"op":"status","id":1,"statusCode":"SUCCESS","connectionClosed":false,"connectionsAvailable":9}
28092020 00:13:41:697: Betfair order stream subscribed.
28092020 00:13:41:697: Betfair order stream connected
28092020 00:13:41:697: Subscribing to orders
28092020 00:13:42:778: Requesting Tennis scores available events.
28092020 00:13:45:056T0: addMarkets(). Market type:UK WIN
28092020 00:13:48:674: Excel quick link settings loaded from: C:\Users\Administrator\Documents\BA_Excel_Workbooks.txt
28092020 00:13:49:971: Excel quick link settings saved to: C:\Users\Administrator\Documents\BA_Excel_Workbooks.txt
28092020 00:13:50:018T0: addMarkets(). Market type:UK WIN
28092020 00:13:52:032T1: addMarkets(). Market type:UK WIN
28092020 00:13:53:485T2: addMarkets(). Market type:RSA WIN
28092020 00:13:53:595T2: addMarkets(). Market type:UAE WIN
28092020 00:13:53:704T2: addMarkets(). Market type:SIN WIN
28092020 00:13:55:064T3: addMarkets(). Market type:IRE WIN
28092020 00:13:56:470T4: addMarkets(). Market type:GREYHOUNDS WIN
28092020 00:13:58:064T5: addMarkets(). Market type:UK WIN
28092020 00:14:01:095T7: addMarkets(). Market type:IRE WIN
28092020 00:14:01:267T7: addMarkets(). Market type:AUS WIN GALLOPS
28092020 00:14:02:954T8: addMarkets(). Market type:AUS GREYHOUNDS WIN
28092020 00:14:04:611T9: addMarkets(). Market type:AUS WIN HARNESS
28092020 00:14:06:111: Subscribing all markets
28092020 00:14:20:051: Searching for Excel instances using path:C:\Users\Administrator\Desktop\New Triggers\, based on path of found workbook:C:\Users\Administrator\Desktop\New Triggers\Gruss Trigger - UK WIN - Rolling Trigger.xlsm
28092020 00:14:20:067: Excel instance found:Gruss Trigger - AUS Harness - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - AUS Greyhound - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - AUS - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - Football - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - SBets New - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - UK Greyhound - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - IRE - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - RSA - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - UK NH - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:Gruss Trigger - UK WIN - Excel
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: Excel instance found:
28092020 00:14:20:067: Excel workbook found:
28092020 00:14:20:067: System.Exception: Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
at Betting_Assistant.ExcelOptions.populateWorkBooks(String openWBName) in C:\Betting Assistant\Betfair Trading API Beta\ExcelOptions.vb:line 814
28092020 00:14:20:067: System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used.
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.ExcelOptions.populateWorkBooks(String openWBName) in C:\Betting Assistant\Betfair Trading API Beta\ExcelOptions.vb:line 823
28092020 00:14:20:067: System.Exception: Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
at Betting_Assistant.ExcelOptions.populateWorkBooks(String openWBName) in C:\Betting Assistant\Betfair Trading API Beta\ExcelOptions.vb:line 814
28092020 00:14:20:067: System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used.
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.ExcelOptions.populateWorkBooks(String openWBName) in C:\Betting Assistant\Betfair Trading API Beta\ExcelOptions.vb:line 823
28092020 00:14:20:067: System.Exception: Cannot create ActiveX component.
Unhadled_Exception File
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'Main'.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Betting_Assistant.PricesStream.readStreamThread() in C:\Betting Assistant\Betfair Trading API Beta\PricesStream.vb:line 202
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()