VBA SalpleCode.xlsm - Non Interactive Login - Get Session Token

[marcello981]

Help!

In file SampleCode.xlsm, is necessary insert the SessionToken in range B4:


Function GetSession() As String
' read from sheet
GetSession = Sheet1.Cells(4, 2).value
End Function

I have the Appkey, Username and Password, but i need a automatic SessionToken find, using these three variables.

Anyone knows a code for this, to replace the code GetSession = Sheet1.Cells(4, 2).value ??

[Grantay.]

VBA function to return session ID

An earlier post http://forum.bdp.betfair.com/showthread.php?t=2491 provides a solution to your request. Note there is a typo in the code bet fair should be betfair in the uri string.

A more elegant solution can be extracted from the SampleSpreadsheet.xlsm. While it is not really a 'non-interactive' solution, it would be a simple process to quickly evolve into a non interactive one - look for the "GetCookieValue" function that is called once the webpage download is completed.

[JoeBloggy]

What spreadsheet is this from please. Where do I download it? Sounds interesting.