Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default word OLEObject in excel


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default word OLEObject in excel


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default word OLEObject in excel


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default word OLEObject in excel


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change and refresh OLEObject showing Excel chart on Access form. Chrisso Charts and Charting in Excel 0 December 23rd 08 04:57 PM
OLEObject question Bragadiru Excel Programming 0 March 15th 05 04:17 PM
Get OLEObject with CSharp Bragadiru Excel Programming 0 November 2nd 04 03:31 PM
OLEObject on worksheet. Trying to get value from it. Grant Excel Programming 4 August 9th 04 06:00 AM
Trying to get/set contents of embedded file using Excel OleObject Rich[_22_] Excel Programming 1 April 15th 04 07:21 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"