Some of my excel sheets have stopped working since API-ING

[macarony]

Public Sub listMarkets()
Dim temp As Collection, b As Variant, mrkt As Market, r As Range
ThisWorkbook.Sheets(4).Cells.clear
If ba Is Nothing Then Set ba = New BettingAssistantCom.ComClass
Set raceList = New Collection
Set temp = New Collection
loadMarkets "GB", 0, 0
loadMarkets "IRE", 0, 0
sortRaces
For Each b In raceList
Set mrkt = New Market
mrkt.name = b
temp.Add mrkt, key:=mrkt.name
Next b
Set raceList = temp
Set r = ThisWorkbook.Sheets(4).Range("A2")
For Each b In raceList
r = b.name
Set r = r.Offset(1, 0)
Next b

When I debug it show the problem starting at temp.Add mrkt, the fault code 456
I assume that there was some changes needed when API-ING came in

[neeeel]

you can get in touch with me and I can take a look

[rourkem]

Hi macarony, can you please share the steps on how you got this to work?

[macarony]

Thanks for the reply but the problem as now been solved by Neil.

[excelhasey]

Can someone explain what API-ING is please

Also when it came in as "Macarony" suggested in this thread

And what effect it has on what and why

Plus do we need to anything ??

Appreciated

[Captain Sensible]

API-NG just refers to the New Generation (NG) API that Betfair brought in to replace the old API last year. No need to get into the technical side of why they brought in the new API and you don't need to do anything as Gruss was recoded to use it.