Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi Did someone know how to take the content of word and do som calculation then write it back to embeded word? Worksheet A --------------------------------------------- word object 1 <-- key in 3 <---- calculate by excel 2 <-- key in --------------------------------------------- Regards, Daro -- daro ----------------------------------------------------------------------- daron's Profile: http://www.excelforum.com/member.php...fo&userid=2745 View this thread: http://www.excelforum.com/showthread.php?threadid=46973 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() In Word 2003, you can Insert Object, select Microsoft Excel Workshee 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 a part of the document Is this what you need? daron Wrote: Hi Did someone know how to take the content of word and do som calculation then write it back to embeded word? Worksheet A --------------------------------------------- word object 1 <-- key in 3 <---- calculate by excel 2 <-- key in --------------------------------------------- Regards, Daro -- Bryan Hesse ----------------------------------------------------------------------- Bryan Hessey's Profile: http://www.excelforum.com/member.php...fo&userid=2105 View this thread: http://www.excelforum.com/showthread.php?threadid=46973 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 -- daron ------------------------------------------------------------------------ daron's Profile: http://www.excelforum.com/member.php...o&userid=27459 View this thread: http://www.excelforum.com/showthread...hreadid=469739 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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. daron Wrote: 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 ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=469739 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change and refresh OLEObject showing Excel chart on Access form. | Charts and Charting in Excel | |||
OLEObject question | Excel Programming | |||
Get OLEObject with CSharp | Excel Programming | |||
OLEObject on worksheet. Trying to get value from it. | Excel Programming | |||
Trying to get/set contents of embedded file using Excel OleObject | Excel Programming |