to import tab prices from unitab (also works with victab with a few small differences & i havent tried nsw as yet)

1. set unitab as your home page in internet explorer
2. open a blank excel workbook
3. from the Data menu select 'Import external data' then 'new web query'
4. wait for the unitab page to load then select the race you wish to import
5. once the race page has loaded you will see a number of small yellow arrows next to each field that can be imported
6. click on the arrow next to 'No.' field - that being the line above the horse numbers & odds etc
7. this should turn the arrow green & highlight all the runners
8. select import at the bottom of the 'new web query' window & choose where you want the data placed
9. you will now have a list of all runners odds, weights etc & the odds can be refreshed by selecting 'refresh data' from the 'data' menu

if you run into any problems then highlight all the imported data & delete, then repeat the above. On occasions the 'refresh data' screws everything up
&you will need to start again.

also you can setup a formatted worksheet so that when you import the data, for example, all the odds at dispayed with 2 decimal places etc.

I would be happy to email the worksheet I use to anyone who is interested.

Stugs


[ This Message was edited by: stugots on 2004-11-06 11:27 ]

[ This Message was edited by: stugots on 2004-11-06 11:33 ]