PDA

View Full Version : Waiting for Excel to Accept DDE Commands



Forrest
13-08-2002, 09:05 PM
Hi there,

I am hoping someone will have come across this one before?

I have 4 Word 200 files that I have mail merged with an address list in Excel 2000.

When I go to open the Word file the following message appears in the status line along the bottom of the screen;

"Waiting for Excel to accept DDE Commands"

Word hangs and has to be shut down with the Task Manager.

Any ideas???

?:|

godfather
13-08-2002, 09:11 PM
Have you tried opening them with the data files already opened in Excel?

parry
13-08-2002, 09:15 PM
mmm this is advanced VBA stuff - hello Graham L are you there???

DDE is a way of sharing data between applications and the problem could be if you are trying this operation from more that one Word doc at the same time. When Word is linking to the Excel file to obtain the records it is creating a temporary link to the file, so if you open another Word doc linking to the same Excel workbook then Word is saying it cant establish the link because the Workbook is already open.

Thats my guess anyway. Are you opening multiple Word documents linking to the same Excel spreadsheet?

cheers
Parry

Forrest
13-08-2002, 09:17 PM
Hi Parry,

No I have the four templates set up but am only trying to open one at a time, it just happens to hang on all four that I try??

F

parry
13-08-2002, 09:29 PM
Interesting. When opening these files do you have one instance of Word, then opening one file after the other? The DDE link is at application level, not the individual Doc so if you open Word, do the MM, then close Word and go onto the next one in this fashion do you have the same problem?

Parry

parry
13-08-2002, 09:36 PM
oops should have added to close Excel as well. So to recap....

1) Open Word
2) Open document with MM (it will open the Excel file)
3) Close Word and Excel
4) Repeat 1-3 for other templates

Forrest
13-08-2002, 10:04 PM
Hi again,

It hangs whether I open Word first then navigate to the file, or if I use Explorer first then double click on the Word file. Excel opens in both cases but Word displays the message in its status bar then nothing.

Thought I should also mention that today I installed Windows SP3,
yesterday the files worked fine? Do you think it could possibly be related?

parry
13-08-2002, 10:14 PM
Perhaps but not sure. Sorry but my hourglass of knowledge on this has just run out of sand. I will have a look at some Word sites tomorrow if I get a chance - anything to get out of work!!

Im not sure whether doing a MM writes VBA code behind the scenes. If so I might be able to decipher it, but otherwise it's a search on the net.

Have you tried putting the exact wording of the error (including the name of the title of the error dialog box) in a search engine like Google?

Forrest
13-08-2002, 10:46 PM
I tried MS Support and technet before coming here, but with no luck, I'll try google and see how I get one.

Many many thanks for your help.

arjen
27-01-2006, 06:05 AM
Hi there,

I am hoping someone will have come across this one before?

I have 4 Word 200 files that I have mail merged with an address list in Excel 2000.

When I go to open the Word file the following message appears in the status line along the bottom of the screen;

"Waiting for Excel to accept DDE Commands"

Word hangs and has to be shut down with the Task Manager.

Any ideas???

?:|

Hi, I also experience the same problems. Howevern ot always and I cannot find the clue. New installation of Office 2000 prof. didn't change anything.
Did you finally get an answer ?
Hope to hear from you,
regards, Arjen