OLE woes--will it ever work well?

  • Thread starter Thread starter David F
  • Start date Start date
D

David F

We have a simple need--embed Excel worksheets in a Word doc, using
Office 2000. Actually, it works--mostly, but in a heavy weight manner.
The file size is large.

Problem: Formatting on the Excel sheet gets cut in half it appears. I
put a wide green border on the sheet. It prints nicely in Excel, but
when embedded into a Word doc, it is narrower. Seems that MS never gets
OLE stuff quite finished, imo. *** Is there a way to make the borders
print correctly? ***

I'm making an estimating guide for bidding purposes. There will be
dozens of sheets. So one document may have a number of sheets embedded.
I wish there was a way to just embed what will actually print, not the
actual spreadsheet itself. I can't find a way to do this. *** Is there
a way to do it? ***

Save as an html file, embed that, all the hidden and/or grouped columns
display. That's dumb. Looks like beta-ware for this feature. I don't
mean to be critical, but it seems that something sold as a suite should
work together correctly.

I'm about to give up on MS and resort to Acrobat for putting things
together. Don't know how well that'll work either.

David F.
 
Hmm, it seems that Word command, Edit/Paste Special/Formatted Text (RTF)
solves the dilemma. Seems to bring text only, and formatting is included
correctly, converted to Word table, which can be edited totally in Word.
Since I'm at home now, I can't know for sure. The tables at work are
much more complicated, with many formulas, grouping, hidden columns,etc.
But I hope it works.

David F.
 
Back
Top