Converting Chart to Picture

[Jim Benet]

What is the macro code to locate and change an Excel graph embedded in a Word
document to a picture? Actually, I have several graphs that need to be
converted.

I have tried the following without success.

Selection.Cut
Selection.PasteSpecial.Picture

and

Selection.Cut
Selection.PasteandFormat (Picture)

 

[Cindy M -WordMVP-]

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

What is the macro code to locate and change an Excel graph embedded in a Word
document to a picture? Actually, I have several graphs that need to be
converted.

I have tried the following without success.

Selection.Cut
Selection.PasteSpecial.Picture

and

Selection.Cut
Selection.PasteandFormat (Picture)

My inclination would be to locate the graph as a field code (Alt+F9 to toggle
codes on/off) then use the .Unlink method on the field code...

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