Insert>Object>File from .XLS to .DOC font color problem

Lorry · Sep 9, 2003

A co-worker asked if I could help with this one, and I've
not been able to solve it. I've not been able to, so
hopefully an MVP can take a crack at it. Anyway, she
created an Excel 2000 9.0.3821 worksheet that used black,
green, and blue text colors. Again, the issue is just the
text, not graphics or charts. This spreadsheet was to be
brought into a larger Word 2000 9.0.3821 document, and is,
by Insert>Object>Create from File>Browse and selecting
the .XLS document. On screen, it looks fine, but all text
prints black (on a color printer). If I select the
worksheet in Excel, Cut/Paste it into Word, then print,
the colors print properly. Of course, there are other
alignment (etc.) problems which is why we weren't wanting
to Cut/Paste, but the font color loss on an
Insert>Object>File is puzzling. Any suggestions? Thanks
for your help.

Shauna Kelly · Sep 9, 2003

Hi Lorry

I find I get the best results by copying from Excel as a picture and then pasting into Word. Or, copy from Excel and paste as a
picture into Word.

Version 1: In Excel, select the range. Hold down Shift and choose Edit > Copy Picture. Choose "As shown when printed" and click OK.
In Word, Edit > Paste.

Version 2: In Excel, select the range. Edit > Copy. In Word, Edit > Paste Special, paste as a picture. Muck around with the options
until you find the one you like. For me, the best one is always Enhanced Metafile. This pasted picture be linked to the original
file if you choose.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
Melbourne, Australia

Lorry · Sep 10, 2003

Thanks, Shauna! It took doing a Paste Special as Picture,
but also having the spreadsheet set up to print on a color
printer. My default is a black and white printer, and
somehow that figured into the solution, after I changed
the printer to the color printer, then the Paste Special
as Picture worked. It didn't work properly until I did
that.

Thanks again for your help.
Lorry

-----Original Message-----
Hi Lorry

I find I get the best results by copying from Excel as a

picture and then pasting into Word. Or, copy from Excel
and paste as a

picture into Word.

Version 1: In Excel, select the range. Hold down Shift

and choose Edit > Copy Picture. Choose "As shown when
printed" and click OK.

In Word, Edit > Paste.

Version 2: In Excel, select the range. Edit > Copy. In

Word, Edit > Paste Special, paste as a picture. Muck
around with the options

until you find the one you like. For me, the best one is

always Enhanced Metafile. This pasted picture be linked to
the original

file if you choose.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
Melbourne, Australia

"Lorry" <[email protected]> wrote in

message news:[email protected]...