Word - Calculate and paste values from Excel sheet

[Augf87]

Hi. My situation is this:

I have a Word document, where I write down some numbers. To get these
numbers, I need to open an Excel sheet, and calculate them using some
primary values and functions I already have, then copying them. What
I'd like to do, is just writing down the primary values in the Word
document and have automatically calculated the resulting numbers by
word, without the copy-paste proccess that I always do.
I have read about linking sheets or macros, but I haven't got a clear
idea of what to do.

Hope it is clear. Thanks in advance
Edit/Delete Message

 

[Doug Robbins - Word MVP]

If the numbers were being entered into FormFields you could use a macro that
runs on exit from one of the formfields to do the calculation.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[macropod]

Hi Augf87,

To see how to do a wide range of calculations in Word, check out my Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party