LT> figures, and do nice underline before the total and double
LT> underline under the total.
LT> How can the same thing be done satisfactorily in Word
LT> without touching excel?
In Word, use tables. The formula for total would be =sum(above). Then use
borders to place a single underline above and double underline below the
total.
You can produce the same results using borders in Excel. Excel even has a
single button to do it in one click.
Embedding excel in Word has the advantage of being much easier to work with
lots of numbers and equations. You also can format numbers easily in excel. I
like to excerpt numbers from a master (complex) spreadsheet by linking. This
way, I can update the master spreadsheet and the Word report is updated
automatically. The disadvantage of the embedded spreadsheet is the overhead.
The document is bigger and the operation is slower. I've found that OLE
became useful with Office 95 and Windows 95 and a Pentium processor with
ample memory. Before these, I considered OLE to be a techno-toy, rather than
a useful work tool. These days, I use OLE extensively for embedding excel
spreadsheets and visio drawings.
Bob
--- timEd/2-B11
---------------
* Origin: The Fireside BBS Houston TX (281)496-6319 (1:106/114)
|