Put simply, I want to extract/identify the price (requested odds) of my current unmatched bets without having to use a MyBets worksheet.
I have the COM interface enabled and have attempted some simple VBA code to get an =getBet funtion:
Function getBet(ref As String)
getBet = ba.getBet(ref)
End Function
Not surprisingly, to me
, this doesn't work and I get a formula result which reads
"BettingAssistantCom.Application.BetDetail"
I realise that the BetDetail is an object with multiple fields and this is probably the reason why I get the result I do. I would be very grateful if someone could help with the VBA code that would either
extract the price field within BetDetail (preferred) or
extract all fields to a specified range of cells.
Many thanks in advance.