COM/VBA help would be appreciated

[tradeaj71]

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.

[alrodopial]

Mark posted elsewhere

"You can download the following Excel file which has example code for all of the COM functions.

See http://www.gruss-software.co.uk/Excel/T ... A_Com.xlsm

[tradeaj71]

Thanks for your reply. That workbook is great but doesn't demonstrate quite what I need in terms of getBet.

Mark is helping me find a solution.