I've had no success in connecting to the COM interface since starting my trial. I've tried various fixes with no luck on either my Win 7 64 bit and XP 32 bit boxes. Asking for help is usually my last option when it comes to computers as I like to learn by trial and error, I'm sure I could work this out in a couple of months, but I'd rather use that time on more fruitful (hopefully) tasks. As this problem exists on both boxes, I'm assuming the problem lies on my end. W7 is connected via a router, whereas Xp isn’t, so I don't think it's a router issue.
Here's a part of my W7 BA_Diagnostic.txt I think might help
12072012 18:50:57:300: 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 Beta 1_1_0_66x68\Betfair Trading API Beta\ExcelOptions.vb:line 688
12072012 18:51:06:988: Searching for Excel instances using path:C:\Users\xxxxx\Desktop\GRUSS\, based on path of found workbook:C:\Users\xxxxx\Desktop\GRUSS\getMarketDepthExample_Async.xls
12072012 18:51:06:988: Excel instance found:Microsoft Excel non-commercial use - getMarketDepthExample_Async [Compatibility Mode]
12072012 18:51:06:988: Excel workbook found:
12072012 18:51:06:988: 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 Beta 1_1_0_66x68\Betfair Trading API Beta\ExcelOptions.vb:line 690
12072012 18:51:06:988: 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 Beta 1_1_0_66x68\Betfair Trading API Beta\ExcelOptions.vb:line 699
I really hope someone can help.
