Holy hot-cakes walkermac.. it works!

Cheers LG

__________________
The trick isn't finding profitable angles, it's finding ones you will bet through the ups and downs - UB

That's great - works for me too. Now I can check out the xml data and compare to their webpage. And hopefully go from html to xml

Thanks for all the help

Ta,
Martin

No worries folks.

Have been comparing between this and their webpage and html and it is looking very excellent. So now I can update my app.

Thanks again for the help.

Ta,
Martin

I am having a problem moving the code to my app.

When I try to compile it comes up "argument not optional" on Set Pool = poolList.Item(J) - it does not like "Pool"

Note I am calling this from a multisheet app - so I have changed all the "Sheet1" to wks (wks as worksheet) as this is what my app uses.

Any help would be greatly appreciated.

I have put the code in a blank wkbk cause my app is huge

Ta,
Martin

Attached Files

wksCodeError.xlsm (19.4 KB, 474 views)

Are you guys working on getting historical results (or have them already) as well or is it still on the TO DO list?

Cheers LG

__________________
The trick isn't finding profitable angles, it's finding ones you will bet through the ups and downs - UB

no, I am working on getting current downloads of divs for races happening now

Ta,
Martin

Sorry, but it works fine at my end. I just added a button to a blank worksheet that called LoadRaceField(ActiveSheet) on being pressed, changed the xml address from cell E-whatever to a string and added a reference Microsoft XML v6.0 (which I presume you've done, as it would've fallen over much earlier).

Code ran through and wrote the odds for the race onto the worksheet; no problems.

If it's still not working for you, maybe upload the whole workbook someplace else and I can have a look to whatever is unique to your situation. ...you haven't done something silly and defined your own function/subroutine called Item, have you?

I have uploaded my Personal wkbk - all 350 odd modules of really badly written code! I have been writing and using it since Feb 2002 - every day.

The Public Sub LoadRaceField(wks As Worksheet) is on mod 104. It showing on OZmium so you should be able to upload it. It is 7828kb

I put the sub in a separate wkbk by itself and it compiled no problem. But not in my Personal wkbk.

Any help you can offer would be greatly appreciated. Now 240am so must go to bed.

Ta,
Martin

Attached Files

PERSONAL.xlsm (7.65 MB, 505 views)

Forgot to mention that the sub is now a public sub with .wks as worksheet. And I have changed the cell references around to fit my workbooks - I download up to 70 races a day.

Ta,
Martin