Word Picture text box font size problem

[Wojciech Drzazgowski]

Hello !
I have a problem concerning a text box font size in Word.

I create a chart in Excel and copy/paste it into a Word document (Excel :
ActiveChart.CopyPicture Appearance:=xlPrinter, Size:=xlScreen,
Format:=xlPicture, then Word : Selection.PasteSpecial Link:=False,
DataType:=wdPasteEnhancedMetafile, Placement:=wdInLine, DisplayAsIcon:=False
).

When I edit the object in Word it is changed to a word picture automatically
and the font size in thex boxes present in the picture changes from 10 (set
during the chart creation in Excel ) to 12. How can I prevent such behavior ?

(Chart creation, copying and pasting is done by VBA macros.)

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?V29qY2llY2ggRHJ6YXpnb3dza2k=?=,

When I edit the object in Word it is changed to a word picture automatically

See your code you posted: it's copying as a picture.

ActiveChart.CopyPicture

You may need to experiment with the available options for how Excel is placing
the information on the Clipboard.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Wojson]

Hi =?Utf-8?B?V29qY2llY2ggRHJ6YXpnb3dza2k=?=,

See your code you posted: it's copying as a picture.
ActiveChart.CopyPicture
You may need to experiment with the available options for how Excel is placing
the information on the Clipboard.

Thanks for your answer!

I don't think it's a clopboard data placement issue, since the picture is
pasted correctly into Word and looks just correct untill I open it for
editing.
The change occurs at the very moment I open the picture for editing. So my
guess is that it's some default settings of a Word Picture object which I
just cannot seem to find anywhere... Any ideas ?

 

[Cindy M -WordMVP-]

Hi Wojson,

I don't think it's a clopboard data placement issue, since the picture is
pasted correctly into Word and looks just correct untill I open it for
editing.
The change occurs at the very moment I open the picture for editing. So my
guess is that it's some default settings of a Word Picture object which I
just cannot seem to find anywhere...

Are you absolutely certain about this? Have you checked which field code is
present immediately after pasting? (Alt+F9 toggles the field codes)

Word will convert an OLE object to a picture if the equivalent of
field.Unlink (Ctrl+Shift+F9) is used on the object. But double-clicking
wouldn't normally cause that.

But if you're copying as a picture (placing on the Clipboard as a picture),
and also inserting as a picture, I expect what you're really getting in Word
is a picture. Double-clicking a picture of the type Excel exports to edit it
will try to open it in Word's picture editor may well have the effect of
changing any fonts in textboxes to Word's default font size (TNR 12).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail