Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP-failure initiating DDE link with MS excel during word mail me
Using MS office 2000 on Windows XP Pro
problem occurs in Word-tools-mail merge-create-form letter-active window-get data-open data source- choose excel file which works on other comp, excel starts doesn't load file and word status message at bottom of window reads "initiating DDE link with MS excel". Word locks up, never returns, have to end task. In excel check "ignore other applications" ok. tried reinstall/add ODBC and Query. What's not installed properly or how get excell to open file? Doesn't work either if file already open in excel or excel even open. |
#2
|
|||
|
|||
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 "doingitall" wrote in message ... Using MS office 2000 on Windows XP Pro problem occurs in Word-tools-mail merge-create-form letter-active window-get data-open data source- choose excel file which works on other comp, excel starts doesn't load file and word status message at bottom of window reads "initiating DDE link with MS excel". Word locks up, never returns, have to end task. In excel check "ignore other applications" ok. tried reinstall/add ODBC and Query. What's not installed properly or how get excell to open file? Doesn't work either if file already open in excel or excel even open. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP-failure initiating DDE link with MS excel | Mailmerge | |||
HELP-failure initiating DDE link with MS excel | Mailmerge | |||
Extra space when pasting link from excel to word as unformatted te | Microsoft Word Help | |||
Link to Excel (Formatting Problem) | Microsoft Word Help | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |