Export OLE Object

Hello,

I have an OLE in a DOORS object (Excel sheet) which is longer than a page. So when i export it, my tab is cut, is there any way to export it on several Word pages?

Thank you.
jlnddn - Tue May 24 07:12:56 EDT 2011

Re: Export OLE Object
rmoskwa - Tue May 24 12:57:39 EDT 2011

I believe that OLEs in Word are restricted to a single page.

You can click-into the Excel OLE in Word, Copy it all (Cntl-A followed by Cntl-C), click-out of the OLE back into the Word doc, and paste. Delete the OLE. You now created an in-line Word table from the Excel OLE object. It will span multiple pages, with repeating heading if you desire.

It is better to use Word OLE tables in DOORS. It is easier to write macros to process the Word doc to convert Word OLEs to in-line than it is to convert Excel OLEs.