PasteSpecial

[Tor]

Hi!

I’m copy a graph from excel, and I want to paste it into a word document at
a named bookmark.

I use the code:

Wrd.ActiveDocument.bookmarks.Item("InsertPic").Range.Select
Wrd.Selection.Range.PasteSpecial Link:=False, DataType:=wdPasteBitmap, _
Placement:=wdInLine, DisplayAsIcon:=False

The bitmap are only partly visible (one line) at the bottom of the image. If
i click on the image in the document, the whole image are selected and shown
as an empty frame.

In the help text for the method I read. When you use this method, the range
or selection doesn't expand to include the contents of the Clipboard.

How can I paste the Excel graph into my document, so the graph are visible?

 

[Cindy M.]

Hi Tor,

The bitmap are only partly visible (one line) at the bottom of the image. If
i click on the image in the document, the whole image are selected and shown
as an empty frame.

I'm wondering if you've got a Line Height setting that's interfering with
showing the entire object? Check the Paragraph format settings for the
paragraph where you're pasting.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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

 

[Tor]

Hi Cindy,

Thanks, it works!