BA beta

[alrodopial]

Tried to install the beta version and it is not recognizing the excel.
tried it twice:
first on xp with excel2010
and
second on windows7 and excel2007

the usual version (65z1) in xp works fine.Did't try it on windows7.

Not a problem for the moment Garry but any ideas?

[GaryRussell]

It's not a widespread problem, there are plenty of people using the Beta version and Excel. The Windows version should be irrelevant.

Are you tring to connect to a spreadsheet that is already open are or are you using the browse button to open the spreadsheet?
Are there any error messages displayed?

Can you send the diagnostic log to admin@gruss-software.co.uk
It is named BA_Diagnostic.txt and is located in "c:\temp\Betting Assistant Logs" folder.

[alrodopial]

20:38:37:915: addMarkets(). Market type:UK WIN
20:38:37:993: addMarkets(). Market type:UK PLACE
20:40:50:837: Searching for Excel instances using path:, based on path of found workbook:
20:40:50:837: 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_66x42\Betfair Trading API Beta\ExcelOptions.vb:line 638

This failed effort has windows and BA installed on hard disk G: and not c:
But the other try I made yesterday was on c:

[GaryRussell]

The line it has failed on does nothing different to previous versions of BA.

Are you sure it isn't a coincidence that this problem has started after installing the latest version? If you uninstall and re-install version 65z1 again I would expect the problem to continue. Can you try this and confirm?

[alrodopial]

65z1 is working fine.Tried it and logs data correctly
The beta has the same problem:
the log:
22:06:51:665: addMarkets(). Market type:UK WIN
22:06:51:712: addMarkets(). Market type:UK PLACE
22:07:12:523: Searching for Excel instances using path:, based on path of found workbook:
22:07:12:538: 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_66x42\Betfair Trading API Beta\ExcelOptions.vb:line 638
22:07:43:364: Searching for Excel instances using path:, based on path of found workbook:
22:07:43:364: 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_66x42\Betfair Trading API Beta\ExcelOptions.vb:line 638

[mickemick]

Just to add I have exactly same problem on one of my PC. Latest BA beta/Excel working with no probs at all on one of them but on another PC seems like BA is not recognizing the excel.

Both PC's with Windows 7/Office 2010...One of them with 64b version of Win/Office (this one works just fine), another is 32 bit versions....

Very strange, issue is resolved when downgraded BA to ver.65z1

[GaryRussell]

Thanks for the diagnostic log, but you didn't answer the following question which is very important in diagnosing this problem.

Are you tring to connect to a spreadsheet that is already open are or are you using the browse button to open the spreadsheet?

[GaryRussell]

Just to add I have exactly same problem on one of my PC. Latest BA beta/Excel working with no probs at all on one of them but on another PC seems like BA is not recognizing the excel.

Both PC's with Windows 7/Office 2010...One of them with 64b version of Win/Office (this one works just fine), another is 32 bit versions....

Very strange, issue is resolved when downgraded BA to ver.65z1

Any chance I could do a remote assistance session on the problem PC so I can see for myself?

[alrodopial]

Thanks for the diagnostic log, but you didn't answer the following question which is very important in diagnosing this problem.

Are you tring to connect to a spreadsheet that is already open are or are you using the browse button to open the spreadsheet?

Sorry , in both cases excel is not recognized.
With the browse I select a file , click open but it doesn't open and nothing appears in BA .
If you want you can also try remote with my pc but later tonight , after the end of races and after you explain how it is done

[GaryRussell]

Thanks for the diagnostic log, but you didn't answer the following question which is very important in diagnosing this problem.

Are you tring to connect to a spreadsheet that is already open are or are you using the browse button to open the spreadsheet?

Sorry , in both cases excel is not recognized.
With the browse I select a file , click open but it doesn't open and nothing appears in BA .
If you want you can also try remote with my pc but later tonight , after the end of races and after you explain how it is done

Do you mean after 8pm UK time? Will you be available at 8.30pm?

[alrodopial]

Do you mean after 8pm UK time? Will you be available at 8.30pm?

I'll probably be.
I will send you a mail at 8.15/8.20 at admin@gruss-software.co.uk confirming it.

[GaryRussell]

Do you mean after 8pm UK time? Will you be available at 8.30pm?

I'll probably be.
I will send you a mail at 8.15/8.20 at admin@gruss-software.co.uk confirming it.

Email can be slow. Can you send a PM through the forum instead?

[alrodopial]

I will.
By the way is betfair down?

[mak]

I will.
By the way is betfair down?

yes!!

[alrodopial]

Gary, will you post a new version for this fix?