Copy / Paste colour formatting

[Dytham]

Any one know of a quick way of preserving text colour when Copy / Paste from
MSP2003 cell to Excel 2003 please ?

(Quick = quicker than having eg. a Flag against coloured cells and copying
the Flag over too)

Chas.

 

[Rob Schneider]

I just tried copy, then "paste special", so i can't find *any* way to
paste while retaining colour. So I guess the flag approach so that you
can tell Excel the "logic" for how to present the colours in Excel the
way to go. To make it a "quick" way ... automate with VBA.

--rms

www.rmschneider.com

 

[Dytham]

Cheers Rob.

It's a bit poor really, seeing as they are both supposed to be Office apps.

C.

 

[Jim Aksel]

You can paste it as a project object, but that is too big. Your only choice
is paste as an image and that is also more than you need. Another tacky
ooption would be a screen scrape program such as SnagIt or what comes with
Vista/
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Rob Schneider]

Gosh, they've given you a very quick way! Just use the VBA (which is an
Office) feature to make it happen!

--rms

www.rmschneider.com

 

[Jack Dahlgren MVP]

No. Not possible.

-Jack Dahlgren