Bookies prices into excel??

[beton]

Now I am stuck. I am trying to transfer the bookie openers , top fluc and SP to my results file.
I have copied from Top Sport and pasted into excel.
I can split the figures into different columns but cannot carry the font colours across.
Green font 4.6, red font 4.6, 4.4


I can carry the green only or have all black but not green, red and black. Next problem will be getting these into their appropriate columns ie Openers, Top Fluc and SP.
I am hoping that somebody has been there , done that and has a solution.
Thanks in advance
Beton

[Shaun]

Just run a formatting macro after you have done the transfer.

[Shaun]

Some of he bookies sites suck badly when it comes to getting the prices where you want them, i have a sheet around here that imported from 6 different sites, was used when we tried to back lower priced lays on betfair, Mark can tell you how well that worked when the bookies got wind of it.

The sheet should have all the formulas and macros needed, just need to find it.

[garyf]

The sheet should have all the formulas and macros needed, just need to find it.Thanks Shaun, Beton & myself would be grateful if you can find it.http://www.propun.com.au/racing_forums/images/icons/icon7.gif

Cheers.
Garyf.

[Shaun]

Sure will take a look, in the process of moving so the main pc is down but should be on my backup drive.

[beton]

Shaun
Thanks
Where are you moving to? You sure picked some good weather. I just lost my back fence.
Beton

[Shaun]

Clarkson area

[Shaun]

What part of Perth are u?

[beton]

Munster.
Really blew down here last night. Lost power briefly. lost the back fence but that's life. and what insurance is for.