Wednesday, February 11, 2009

Re: Conversion of Excel to Word

On Feb 11, 2009, at 12:20 AM, Arun Kumar wrote:

> I made calculation sheets in MS Office EXCEL for the ease of
> calculation. But my deliverable must in MS Office WORD. So I copied
> and paste the whole content from excel to word, in a new file.

I do the same thing with pressure vessel calculations, but I use the
print merge function to fill out each calculation sheet with the
numbers from Excel. You can see how the print merge function works
from the MS Word help. The calculation sheet form is saved with
explanatory text and algebraic expressions with with placeholders for
the Excel data. When you're finished with the Excel calculations, you
write off the data into a text file and use the print merge menu pick
to fill out the sheet.

It makes for very neat calculations that have all the advantages of
automated calculations and all the advantages for appearance and
checking with manual calculation. And it's fast.
Christopher Wright P.E. |"They couldn't hit an elephant at
chrisw@skypoint.com | this distance" (last words of Gen.
.......................................| John Sedgwick, Spotsylvania
1864)
http://www.skypoint.com/members/chrisw/

******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
* http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********