PasteSpecial from Excel to PPT - how can I keep the colored fonts?

C

Colleyville Alan

I am pasting info from Excel to PPT. Most of the info uses black fonts but
I am highlighting some info using blue fonts. When I choose PasteSpecial
and then EnhancedMetaFile, all of the info shows with black fonts.

If I use the bitmap option, it shows with blue font, but the resolution
quality is far less. I thought there was a way to use the EMF specification
and still have the font color show up correctly. Am I mistaken, or is there
some setting in either Excel or PPT that I need to fiddle with?

Thanks
 
U

Ute Simon

Colleyville Alan said:
I am pasting info from Excel to PPT. Most of the info uses black fonts but
I am highlighting some info using blue fonts. When I choose PasteSpecial
and then EnhancedMetaFile, all of the info shows with black fonts.

If I use the bitmap option, it shows with blue font, but the resolution
quality is far less. I thought there was a way to use the EMF specification
and still have the font color show up correctly. Am I mistaken, or is there
some setting in either Excel or PPT that I need to fiddle with?
When copying the info in Excel, hold the Shift-key and choose "Edit" -
instead of "Copy" you will see "Copy image". In PowerPoint use "Paste
Special" and Enhanced MetaFile.

This should do the trick.

Kind regards,
Ute
 
E

Echo S

This has cropped up here before. I think you have to have a color
printer set as default in order for the font colors to stay. Maybe?
Something like that?
 
J

John Langhans [MSFT]

[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

To me, this sounds like a problem/limitation with how Excel is creating the
rendering for its OLE objects (as well as other clipboard formats that it
is creating when you use the Copy command in Excel).

One of the first steps for troubleshooting OLE objects is to isolate
whether the problem is in the container (in this case, PowerPoint) or in
the server (in this case Excel).

To isolate the problem:
1) First try a different container applications. I usually recommend
WordPad since it's the most generic OLE container and it ships with Windows.
a) Insert same object into WordPad
b) If applicable, perform same operation on object (if possible) that you
performed in other container (such as resizing object)
c) Does the problem occur in both containers? - If so, the problem might
be with the source application or just an OLE limitation

2) Try different source applications: Which ones I recommend would depend
on the problem. However, it is not always possible to find another source
application which provides a rendering of it's object in the same way so
you might not be able to definitively determine whether it's a container
application problem (because it occurs with multiple source applications).
a) Insert different source object into the same container application (in
this case, PowerPoint)
b) If applicable, perform the same operation on this object that you
performed on the other object (such as resizing object)
c) Does the problem occur with this object? If not, repeat steps 2a-2c
with additional source applications.

So:
* If the problem occurs with only 1 source and multiple containers -> Most
likely a problem or limitation with source application
* If the problem occurs with only 1 container and multiple sources -> Most
likely a problem or limitation with container application
* If the problem occurs with multiple container and multiple sources ->
Most likely a limitation of OLE technology

As always, if you (or anyone else reading this message) have suggestions
about how PowerPoint and Office interoperability (such as Object Linking
and Embedding) should be improved, don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions)

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
C

Colleyville Alan

Echo S said:
This has cropped up here before. I think you have to have a color
printer set as default in order for the font colors to stay. Maybe?
Something like that?

Thanks. Your answer allowed me to find the info in detail. It turns out
that your answer is absolutely correct.

Whether holding Shift and choosing Edit|CopyPicture or using VBA and the
CopyPicture method, there are two options:
1 - you can copy the picture using the way it is displayed on the screen
(keeps colors, but truncates some of the colums)
2 - you can copy the picture using the way it will be shown on a printed
page (does not truncate the columns, but shows color only if the default
printer is a color printer; else it shows B&W).

If I have to set the default ptr to a color ptr and reset it at the end of
my sub, it will be one of the more minor workarounds in my spagetti-coded
system.

Thanks for your help.


--
Echo [MS PPT MVP]
http://www.echosvoice.com

Colleyville said:
I am pasting info from Excel to PPT. Most of the info uses black fonts but
I am highlighting some info using blue fonts. When I choose PasteSpecial
and then EnhancedMetaFile, all of the info shows with black fonts.

If I use the bitmap option, it shows with blue font, but the resolution
quality is far less. I thought there was a way to use the EMF specification
and still have the font color show up correctly. Am I mistaken, or is there
some setting in either Excel or PPT that I need to fiddle with?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top