as there seems to have been a bit of interest around about importing prices into excel heres how -

to import tab prices from unitab (also works with victab with some 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:31 ]

That would be great thanks in advance.

mahato@bigpond.net.au

Yes thanks...i do it differently but that sounds good

the way i do it with OFFICE 2000 PRO is i go to the tab page and then i right click the page with the information i want then go to properties...this will show me the url i need i then copy this and go to data get external data copy the url in and then select how much formating and tables i need and that will place it on the doc...what excel are you using

can u send me e-mail to shaun2166@hotmail.com

[ This Message was edited by: Shaun on 2004-11-06 12:40 ]

[ This Message was edited by: Shaun on 2004-11-06 12:41 ]

hi dino & shaun - files have been emailed.

shaun i am using excel 2000

stugs

not sure why it won't work your way do you log in to Unitab i just use the page that is displayed and the url link at the top is the same for every page.....from what i can see my way works the same as yours same info....so thats cool...i did try it on vic tab and works...pitty it does not work for WA tab...but that ok cause we use Stab prices anyway http://www.tabonline.com.au/cgi-bin...page=/today.htm


[ This Message was edited by: Shaun on 2004-11-06 13:45 ]

you cant get it to work on uni?

i got it working on Uni tab but not the way you discribe...read my other post thats how i do it

chucky_s_3000@yahoo.com.au

thanks a lot in advance...

i've tried to do it on many occasions, but there is never an arrow next to no. ...

Chuck

well you need to reread my instructions cause thats the way she works

chuck you might try selecting the race you want before the unitab main page has fully loaded - that is before any yellow arrows appear on the main page.

hope that helps, if not i dont know what to tell you as i have run thru my instructions again to ensure nothing was left out & the process works exactley as described, as i have been using it for some time now.

i use internet explorer & excel 2000.