word OLEObject in excel

[daron]

Hi
Did someone know how to take the content of word and do some calculation then write it back to embeded word?

Worksheet A
---------------------------------------------
word object

1 <-- key in

3 <---- calculate by excel


2 <-- key in

---------------------------------------------


Regards,
Daron

[Bryan Hessey]

In Word 2003, you can Insert Object, select Microsoft Excel Worksheet and use the 'window' as sized as a set of cells with Excel functions.
You can format-cells select White as the Pattern to have it look as part of the document

Is this what you need?

Hi
Did someone know how to take the content of word and do some calculation then write it back to embeded word?

Worksheet A
---------------------------------------------
word object

1 <-- key in

3 <---- calculate by excel


2 <-- key in

---------------------------------------------


Regards,
Daron

[daron]

Hi ,
Actually, I want to insert an word object into excel. Now, I manage to insert an object by selected word document in excel worksheet. But the problem is i dont know how to get the data from word when i edit it on excel and write it back again after i do some calculation.

Hope someone can give some guidances

Regards,
Daron

[Bryan Hessey]

Unfortunately not I.
You can, as you have done, insert the Word document and amend that insert, or rightmouse-Document Object-Open, but in neither case can I get the results to save (the latter may be possible, but not when under WorkSite control).

You could edit the document via a Hyperlink setup, but again, this is not what you seek.

Good luck in your quest.

Hi ,
Actually, I want to insert an word object into excel. Now, I manage to insert an object by selected word document in excel worksheet. But the problem is i dont know how to get the data from word when i edit it on excel and write it back again after i do some calculation.

Hope someone can give some guidances

Regards,
Daron