Missing Info

[markkirwan]

I thought I set the software up and linked it to a Excel spreadsheet but the sheet has no information (e.g. horses, odds etc)I do have an Excel Error Log with loads of rows with the following in the Error column: (the other columns have a time in and in the action column it has "writing odds")


System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateSet(Object o, Type& objType, String name, Object[] args, String[] paramnames, Boolean OptimisticSet, CallType UseCallType)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateSet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean OptimisticSet, Boolean RValueBase, CallType CallType)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateSet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments)
at Betting_Assistant.Excel.setCells(Object xlRange, Object[,] wCells, String action)

can someone please help me to set up

Mark

[GaryRussell]

I can replicate this problem if I protect the worksheet. Do you have this problem on a new blank workbook? If you don't then it does suggest that the workbook you are having the problem with has it's cells protected from being written to and you need to unprotect them.

[markkirwan]

I found out the problem was due to me running excel 97. I have upgraded to office 2007 and it runs fine now.

Thanks
Mark

[roseadison]

Hi I heard that Microsoft released new version of office that is office 2010. I wanted the review of it. How is it?? Is anyone had used it??