Link Word Fields to and from an Embedded Worksheet

[RPJ]

I believe I have the same requirement and frustrations as "Drew" who posted a
question on 10/04/2006: The need to reliably link into and out of an Excel
Worksheet that has been embedded in a Word Document - wherever that document
is stored.

I want to be able to construct a Word Template which creates Word Documents
that allow you to enter a value in a Word Form Field (for example) - that
field is linked to a cell in an embedded Excel worksheet and its value is
used to calculate results in other cells - that are then linked back to
Fields within the host Word Document. The OLE linkage must NOT be dependant
on where the host Word object is stored.

This proposed integration of (embedded) Excel Worksheet and Word Document
functionality is surely the one of the main reasons for inventing OLE in the
first place.

I look forward to any responses / support that this suggestion generates.

RPJ

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...587ba3a6&dg=microsoft.public.word.vba.general

 

[macropod]

Hi RPJ,

Unless you're trying to do something that can't be done using Word's formula
fields or vba, there seems to me to be no need to resort to embedded Excel
objects. Your Word document's formfields should be able to trigger a formula
field recalculation and/or the running of a macro to do the grunt work. In
either case, the results can be output to a Word table.

Cheers

--
macropod
[MVP - Microsoft Word]

I believe I have the same requirement and frustrations as "Drew" who posted a
question on 10/04/2006: The need to reliably link into and out of an Excel
Worksheet that has been embedded in a Word Document - wherever that document
is stored.

I want to be able to construct a Word Template which creates Word Documents
that allow you to enter a value in a Word Form Field (for example) - that
field is linked to a cell in an embedded Excel worksheet and its value is
used to calculate results in other cells - that are then linked back to
Fields within the host Word Document. The OLE linkage must NOT be dependant
on where the host Word object is stored.

This proposed integration of (embedded) Excel Worksheet and Word Document
functionality is surely the one of the main reasons for inventing OLE in the
first place.

I look forward to any responses / support that this suggestion generates.

RPJ

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...587ba3a6&dg=microsoft.public.word.vba.general

 

[RPJ]

The Excel Worksheet I have in mind in the scenario I described contains a
simple table (~12 rows x 13 cols), an "input" cell (which I wished to have
linked to a Bookmarked field in the host Word document) and 7 "output" cells
that are populated from the contents of the table depending on what has been
"input". The (7) Excel formulas used would make extensive use of the VLOOKUP
function. Linking the "output" cells back to the host Word document would
populate fields in various places.

It is the ability to store and interrogate a single matrix of information,
using Excel's broad and more user-friendly (compared to VBA) functionality,
that gives rise to this essential request.

The key issue that cannot be avoided is the non-interoperability of
(unstable) OLE links between the host and the embedded object: two key
Microsoft Office products that won't talk to each other (or which have not
been enabled to do so).

RPJ

Hi RPJ,

Unless you're trying to do something that can't be done using Word's formula
fields or vba, there seems to me to be no need to resort to embedded Excel
objects. Your Word document's formfields should be able to trigger a formula
field recalculation and/or the running of a macro to do the grunt work. In
either case, the results can be output to a Word table.

Cheers

--
macropod
[MVP - Microsoft Word]

I believe I have the same requirement and frustrations as "Drew" who posted a
question on 10/04/2006: The need to reliably link into and out of an Excel
Worksheet that has been embedded in a Word Document - wherever that document
is stored.

I want to be able to construct a Word Template which creates Word Documents
that allow you to enter a value in a Word Form Field (for example) - that
field is linked to a cell in an embedded Excel worksheet and its value is
used to calculate results in other cells - that are then linked back to
Fields within the host Word Document. The OLE linkage must NOT be dependant
on where the host Word object is stored.

This proposed integration of (embedded) Excel Worksheet and Word Document
functionality is surely the one of the main reasons for inventing OLE in the
first place.

I look forward to any responses / support that this suggestion generates.

RPJ

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...587ba3a6&dg=microsoft.public.word.vba.general