tracking workbook

I think its a log-in problem. When I try to download a race into Excel it says I have not logged in. Looks like the problems with Lite are not over yet.

anyone know what they were trying to**

the problem with the error message "getMarketName = reMatches(0).SubMatches(0)" is that it its looking for a patternthat is no longer there....
click on debug and find the Privatte Function getMarketName()
change the line of text saying
marketNameRegExp.Pattern = "strong(.*)/strong(.nbsp.. In-play .)*br"

to

marketNameRegExp.Pattern = "STRONG(.*)/strong BR"

works for me.....
Looks like the log in cookies are being refreshed at quicker intevals than before the site went down - bad news if you are trying to place bets using the spreadsheet. still ok for monitoring though

(marketNameRegExp.Pattern = "STRONG(.*)/strong BR")

We'll make that change to the workbook - thanks for the**

I understand the timeout change is a compliance requirement imposed on us.

Larry - why can't I download data from Lite into Excel now?

It might be because of this MS Office issue: http://support.microsoft.com/kb/290347

I'll have a look.

Larry

Why can't I download into an Open Office Calc spreadsheet now?

thanks SBP, changed line about regex pattern as you suggested, but i get

'run time error 5 invalid call procedure or argument'

any more help please?

Whoever can get the workbook going again will become my new hero!

I thought waiting for lite to reappear was annoying enough, but when it returns and it has changed so the workbook is not working.

A huge thanks to all the folks working on getting it going again.

jamie pullen-
for some reason when I pasted what the line should read the forum re-edits despite it looking correct in the preview..... dont just copy and paste it in from the forum

it still needs the (greater than symbols) in there (the characters that are on the comma and full-stop keys on your keyboard).

all you need to do is delete (.nbsp..Inplay.)* from the original line and make sure the BR at the end has a space. The BR needs to be surrounded by a greater than and less than symbol.

I am really struggling to get the tracking workbook going.

I have used the previous suggestions but I am still getting

Run-time error '5': Invalid procedure or argument

when I get to clicking the Track Market button.

When I press debug,

getMarketName = reMatches(0).SubMatches(0)

is lit up in yellow.

Has anyone any suggestions?

thanks sbp, not been back for a while, disheartened by the whole shutting lite and then ruining my workbook fiasco!

anyway, back now and just tried your suggestion. Had to also remove:

If UserCookie = "" Then
MsgBox "You must be logged in to track this market"
Exit Sub
End If

otherwise it told me i needed to log in when i already was!

Am i right in reading above that it will also log me out after a while, my sheet was set to place bets while i was at work. if this is the case then i guess my sheet is still next to useless!
:(

yep it will log you out unfortunately. Before they made changes to the betfair lite website you could log in for ages(not sure how long but was definately for hours). Now your user cookie details log out after 5-10mins. you then need to log back in again.

not best at excel, but could i have a browser window hidden that is logged on that resfreshes every time workbook does to keep connection or would this not work either? spent months teaching myself excel to get workbook to do what i want and then they spoil it!!

when sheet logs out, i loose odds, names etc on each race sheet. however, if i open up the browser and log back in, on next workbook refresh the data reappears, so there must be a way to automate this for when i am at work. Like i said, i am self taught and not so good, but i will try.

by the way, as a neater approach, if it will work has anyone got some code that will log on without having a hidden browser window?

I can then run it every 2 minutes or so to keep logged in (hopefully)

Thanks for all your help with getting the tracking workbook going again.

I can now login, start tracking the market, but it won't accept any bets. According to the "Bets Journal - Master", there is an "Unknown Error".

Anybody got it actually taking bets or any suggestions?

:x

ttt

.

.