Sample Triggered Betting Spreadsheets

[xraymitch]

Hello Gary,

In an effort to learn more about Excel I download your com class examples which you created over 8 years ago or so.

Whichever spreadsheet I run gives "Run Time Error -2147221164(80040154) Class Not Registered"

Debug shows in yellow always at the same line "Set ba = New BettingAssistantCom.ComClass"

I am using Excel 2016 with Windows 10 Pro and BA ver 1.3.0.45m

I am way out of my depth but have included a screenshot showiing the References that are enabled.

As this is not an urgent matter please advise when you get a chance.

Many thanks

References

sauU1tglf3.png (217.72 KiB) Viewed 24055 times

[GaryRussell]

You may need to do a re-install to register COM. Uninstall from the control panel then re-install from the following link.

http://www.gruss-software.co.uk/Betting ... istant.msi

[xraymitch]

Thanks, I will give that a try later today and report back.

[xraymitch]

Frustrating - I have reinstalled BA and Excel, all to no avail.

Have spent hours this last week searching on the error "Run Time Error -2147221164(80040154) Class Not Registered" but will continue to search in the hope of coming up with a solution.

Thanks

[GaryRussell]

Is your office installation 64 bit? If so try the following.

Open a command prompt in admin mode then enter the following two commands.

i) cd C:\Windows\Microsoft.NET\Framework64\v4.0.30319
ii) regasm /codebase "c:\program files (x86)\Betting Assistant\BettingAssistantCom.dll"

[xraymitch]

Brilliant - that has fixed it.

Thanks a million.

[daveat91]

Hi just downloaded this sample lay sheet...it's just what I want for laying greyhounds...however I would like to lay the fav at BFSP is this possible..if not is it possible for me to lay at say 15 secs...any reply would be much appreciated

http://www.gruss-software.co.uk/Excel/Lay_Favourite.xls

[xraymitch]

Brilliant - that has fixed it.

Thanks a million.

Hi Gary,

Thought your last advice had sorted everything.

I have recently started experimenting with your example spreadsheet getMarketDepthExample_Async.xls which works perfectly provided Excel Log Current Prices is always the first Tab Page selected.

By way of an example, the order of Tab Pages for today's (22-08-20) UK Racing are Uttoxeter, York, Sandown, Chelmsford City, and if I wanted the MarketDepth for the 3rd Tab Sandown then it would load the selections etc but all values from cell(Z5) onwards would be filled with 0.00.

I have to delete the 1st and 2nd Tabs to make Sandown the first Tab to get cell(Z5) onwards filled correctly with MarketDepth values.

Any thoughts on what can be done to solve this are much appreciated.

Thanks

PS Apologies for double posting at viewtopic.php?f=1&p=54134#p50232

[GaryRussell]

I will take a look and get back to you.

[xraymitch]

I will take a look and get back to you.

Much obliged.

[MarkRussell]

Hi,

Gary's example was only designed to work with one tab page.
I have updated it to use multiple tab pages linked to different Worksheets so that you can link the different venues to their own sheets and have the market depth on each sheet.
I've set it to allow for 6 venues but you could add more.
It's very important that when you link Betting Assistant to this Workbook that you link the tab pages in order.
When you open the Workbook you will see I have named the sheets venue1, venue2, etc
And when you do the linking you must use venue1 for tab page 1 and venue2 for tab page 2 etc.
This is because the VBA sitting behind each Worksheet sets the COM tabIndex property before calling the getMarketDepth function so that it knows which tab page the getMarketDepth relates to.

Download the Workbook using the following link:-
http://www.gruss-software.co.uk/Excel/getMarketDepthExample_Async_multisheet.xlsm

Regards,
Mark

[xraymitch]

Hi Mark,

Gary's example was only designed to work with one tab page.

I suspected that might be the case and tried to amend it but it was beyond my basic VBA skills.

Big THANKS for taking the time to update the code which also gives me further examples to learn from.

regards

[NorthView]

Hi Gary/Mark

I've followed the steps above on my Win 10 laptop with Excel 365...

Downloaded the multisheet xls from the link
Removed and reinstalled the latest BA (49c)
Registered the dll in a cmd prompt as above
In Excel365 Options/Add-ins: Manage COM Add-Ins, Go. selected C:\Program Files (x86)\Betting Assistant\BettingAssistantCom.dll, but get error message "C:\Program Files (x86)\Betting Assistant\BettingAssistantCom.dll not a valid Office Add In".

Please can you help?

[NorthView]

Ok, I think I've realised that registering the dll via the cmd line does away with the need to Add it in via Excel, because it's connected to a racing market and logging prices without error.