 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / October 2006Paste OLE objects into Word
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? Hi Thejosher@bigfoot.com, > 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 [quoted text clipped - 6 lines] > 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 :-) Thanks, I used the inlineShape collection to resize all the objects in the document to the correct column width. > Hi Thejosher@bigfoot.com, > [quoted text clipped - 25 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.