VBA Developer: convert program to new API

[IainMack]

Hello, I have a program developed a couple of years ago that I now want to take another look at. I can and will supply the existing Visual Basic code, all I need is that program converted to the new API. (Or if it is easier for you - eg clone an existing program - a basic program to list track, event, runner details at different time intervals before and after the off.)

[StefanBelo.]

Have a look at bfexplorer and its features allowing you to customize bfexplorer for your solution. If you are a little bit familiar with programming then you can use bfexplorer bot sdk, otherwise you can contact me with your detail specification and I will build your solution on bfexplorer platform.

[IainMack]

Thanks, but I don't want something built on another platform. I have used many "bots" over time and then I wrote my own because none of the bots did what I needed.

I need an existing Visual Basic program converted to the new API. That's it. If you can do that please respond.

[Grantay.]

VBA version of new API

I have developed VBA version of the new API - running in Ms Access.

Depending upon how complex your application is I may be able to help. VBA does not handle List (of T) at all and I substitute array lists. I have also incorporated a decent json parser so that is handy as well.

Send me a pm if you wish to discuss

Grantay

[Lopiner]

Grantay, just curious, did you organize you stuff using collections or arrays of objects?

[Grantay.]

VBA and Betfair

Grantay, just curious, did you organize you stuff using collections or arrays of objects?

Most of my VBA work on BF utilises vb.net com addins that I write in VS 2013 - then hook up via references in Access. I convert any List(of T) type objects to ArrayLists, and declare objects in Access to hold the data.

thus:

Dim arlstMIDList As Object
Set arlstMIDList = CreateObject("System.Collections.ArrayList")

arlstMIDList.Add oBetfairLib.fnGetMIDList("AU", "Horses")

I also use Collections:

Public Function fngetPrices(strMarketID As String) As Collection

Dim RaceBook As New NewApiClassLib.MarketBook
Dim colPrices As New Collection
Dim oPrices As New clsRunnerPrices
Dim oRunnerPrices As New Dictionary

I found this approach much simpler than trying to adapt the Excel version of the new API to my needs. VS provides a much better IDE than Access - the Newtonsoft json parser is a real delight. Most of my work is in Access, I find VBA very powerful for most things I need.


Grantay