Use ctrl-F9 to insert the special field braces {}
Type "dde excel system sysitems" (without the quotes) between the { and
the }
Select the field (normally, selecting one of the braces is enough).
Press F9 to execute it.
Alt-F9 toggles between "field codes" view and "field results" view.
Peter Jamieson
"doingitall" wrote in message
...
Thanks for reply. I understand your thought process, could you please
give
me more detail on how (the key strokes) you were thinking of to "put the
following field { dde excel system sysitems }" and "execute it".
Thank you
"Peter Jamieson" wrote:
I doubt if I can help but can you please try the following?
a. start Word
b. start Excel
c. in a blank Word document, put the following field:
{ dde excel system sysitems }
d. select the field and execute it. Use Alt-F9 to show the result - if
the
field executes correctly, you should see something like
SysItems Topics Status Formats Selection
Protocols EditEnvItems
I am interested to see whether /any/ DDE connection is being made.
If that works, try
{ dde excel system topics }
You should see
[Book1]Sheet1 [Book1]Sheet2 [Book1]Sheet3
System
If that works, try opening your Excel document, and re-execute the { dde
excel system topics } field. You should see the names of some sheets in
your
workbook, e.g.
[Book1.xls]Sheet1
then try
{ dde excel [Book1.xls]Sheet1 R1C1 }
using the name from the previous step instead of [Book1.xls]Sheet1
Peter Jamieson
|