the full days download
go to sheet 3 and put the date in cells b1 to d1
invoke macro by clicking " prices and results" button
days program data on sheet 1 - doesn't show jockey or barrier though
days results W&P in sheet 4

i then link to another spreadsheet you can then pick up into another spreadsheet

Attached Files

	tatts xml tester.xlsm (139.8 KB, 602 views)
	tatts xml tester 97.xls (377.5 KB, 535 views)

Up s creek here without a long boat or a paddle - just opened the 2nd version and pressed the Prices & Results button...

Run time error 438
Object doesn't support this property or method

Don't you just hate it when that happens??

LG

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

Hi Aussie - thanks for that.

Unforetunetly it does not fix my problem. My app automatically downloads the divs and win pools at preset intervals for 30 mins up to the gate closing. It does this on up to 70 works sheets a day depending on how many races there are. It then runs an analytical package to see if each race is a bet or not.
Over the years I have focused on the analytical package. I was using xml schemas to get the xml feed but when Tatts took over the downloads got very shonky. So I went back to html. Now I have some time I am trying to get back to xml feed.
The problem is Shaun's code is for a single sheet, mine is multiple sheets. And I am not a good programmer. So when an error message comes up I tend to hit the wall. I did manage to get the race number to load - do not ask me how!
But now I need to get "Pool" to become an optional argument. This is not a problem as a single sheet app but multisheet is a no go.

Ta,
Martin

Hi Lord,

By 2nd I take it you mean the '97 version, sounds like something is either not supported or not loaded in Tools, References of your version of xl.

Other than that.....up the same creek.

Ta,
Martin

yes it seems like a few references have to be opened.
i have attached a picture of what they should be:

right click and open in a new tab.
i couldnt post a picture

Thanks Aussie,

I have all of those opened. I also had a bunch of soaps open which I have now closed. Plus I have MD Forms 2.0 Object Library which I cannot close as it is being used whereas you have it closed.

Ta,
Martin

and you are using office 2010 or 2007

another way would be for you to copy each macro into your own version of excel and step by step through it to see what happens.

i don't recall doing anything overly fancy

I am in 2010. I have copied it into my own wkbk but not happening. The step by step thing would be a huge exercise even with only a 10 race book. I really need to get the thing to compile first and that means getting past the issue with it not accepting the pool issue.

Ta.
Martin

ok strip out what you don't want me to see and upload a copy of your workbook and i will see if i can get it to work.

cheers

aussie