Thread: Fastest Tote
View Single Post
  #7  
Old 26th August 2005, 10:49 AM
SeeDee SeeDee is offline
Member
 
Join Date: Apr 2005
Posts: 39
Smile Excel Fun

Dingo...

Your presentation is much better than mine. Believe it or not, I print out the day's races ON PAPER!. Again I have a macro (cos I'm a lazy sod). I go to WA tab, Racing Info, Today's Races and select all and copy. I click on my macro button and it copies into excel (Special, Text), expands into columns if necessary and deletes all columns except Time, Track, Race and No of Runners. This is then copied into my daily worksheet.

Shaun....

Again with the macro! I copy from WA tab race screen and press my button which pastes into my spreadsheet (Text, Special) and expands into columns. All the details I need are there. If you are interested I can send you a version of the macro I use. It can be adapted if you know your way around macros. If my system pans out I guess one day I will convert it to VB.

As I try to compare lots of data from TAB, I would be very interested in how the interface works. I know it is there because some of the shyster products currently being vilified (quite rightly) on this forum use it. Any information would be appreciated.

Oh, to answer your question, yes I have WA Tab open on two pages one for race details, which I copy and analyse and one on the expert screen. As I said earlier, the last macro statements highlights and copies my selections so I just right mouse once on the expert screen and select paste then press "Log bets". I was interested in your approach in the hope that it would allow me to keep only one screen open and reduce actions by me.
Reply With Quote