Hi,
Odd start to day ...
Logged in to Gruss , and connected to a Workbook. I set a Breakpoint against the " If Target.Columns.Count <> 16....." as below - and there is no response, ie the macro doesn't seem to be running. Can see data updating in Excel.
- Code: Select all
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count <> 16 Then Exit Sub
Checked ExcelLinkActivity - seems ok Requesting Excel Refresh ..... Excel Updated
Excel ErrorLog is showing an error, cant cut and paste : System.Runtime.InteropServices.COMException(0x800AC4 there is more
Checking BA_Diagonistic
9102015 13:23:32:850: 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 Next Gen API\Betfair Trading API Beta\ExcelOptions.vb:line 746