excel link doesn't work

Please post any questions regarding the program here.

Moderator: 2020vision

excel link doesn't work

Postby clinton » Mon Aug 28, 2023 1:12 pm

Hello

after a long time tried to link BA and excel like i did a million time before, but it doesn't work.
Excel worksheet remain totally blank.
I have seen this error looking for:

14:07:57:779: Requesting Excel refresh. Origin cell:A1
14:07:57:779: Excel update skipped. First update after market changed.
14:07:58:28: Requesting Excel refresh. Origin cell:A1
14:07:58:44: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 4323
14:07:58:44: Excel updated.
14:07:59:28: Requesting Excel refresh. Origin cell:A1
14:07:59:28: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 4323
14:07:59:28: Excel updated.
14:08:00:44: Requesting Excel refresh. Origin cell:A1
14:08:00:44: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 4323
14:08:00:44: Excel updated.
14:08:01:28: Requesting Excel refresh. Origin cell:A1
14:08:01:28: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 4323
14:08:01:28: Excel updated.
14:08:02:44: Requesting Excel refresh. Origin cell:A1
14:08:02:44: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 4323
14:08:02:44: Excel updated.
14:08:03:29: Requesting Excel refresh. Origin cell:A1
14:08:03:29: Severe error:System.Exception: Cannot create ActiveX component.
in Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
in Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:riga 1940
in Betting_Assistant.Excel.ExcelUpdateThread(Boolean triggersOnly) in C:\Betting
.
clinton
 
Posts: 109
Joined: Mon Oct 22, 2007 12:25 pm

Re: excel link doesn't work

Postby clinton » Mon Aug 28, 2023 1:12 pm

If possible need help
clinton
 
Posts: 109
Joined: Mon Oct 22, 2007 12:25 pm

Re: excel link doesn't work

Postby GaryRussell » Tue Aug 29, 2023 9:03 am

Make sure no pending Windows updates and reboot PC.

Make sure you aren't running Excel or Betting Assistant in Administrator mode. If you need either of them to run in admin mode then run them both in admin mode.
User avatar
GaryRussell
Site Admin
 
Posts: 9695
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: excel link doesn't work

Postby clinton » Tue Aug 29, 2023 9:46 pm

TY a lot for your reply, but I found the solution in an old post: my excel file was in dropbox. I saved it locally and works perfectly :-)
clinton
 
Posts: 109
Joined: Mon Oct 22, 2007 12:25 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 87 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.