Paste OLE objects into Word

[thejosher]

In MS Word, when I paste an OLE object into a table from an external
source, it remains its original size, even if that OLE object is so
large that is spans invisibly beyond the right edge of the cell.
However, when I cut that same object in word and paste it back into the
same place, it automatically resizes to fit the cell.

I am using VBA to export OLE objects from an external source, and I am
looking for an automated way to resize all the OLE objects that are
pasted into a cell as an RTF formatted string. Is there a way to easily
do this?

 

[Cindy M.]

Hi (e-mail address removed),

In MS Word, when I paste an OLE object into a table from an external
source, it remains its original size, even if that OLE object is so
large that is spans invisibly beyond the right edge of the cell.
However, when I cut that same object in word and paste it back into the
same place, it automatically resizes to fit the cell.

I am using VBA to export OLE objects from an external source, and I am
looking for an automated way to resize all the OLE objects that are
pasted into a cell as an RTF formatted string. Is there a way to easily
do this?

Hard to say, based on what we know... If you go over Edit/Paste Special
and try the options listed there, do any give you a "better" result?

If you perform this paste in the Normal view (gives you more leeway to
"grab" objects that exceed the visible bounds), then resize using the
object "handles", do you get an acceptable result? If yes, then you can
successfully manipulate the object as an InlineShape to resize it using
VBA.

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

 

[thejosher]

Thanks,

I used the inlineShape collection to resize all the objects in the
document to the correct column width.