Ask the Expert

Getting error when merging a Word doc with an Excel file saved from .csv file

Hi, John. When I attempt to merge a Word 2000 document with an Excel 2000 file (saved from .csv), I am getting this error: "Word could not re-establish a DDE connection to Microsoft Excel to complete the current task." Not every single file, but only rather lengthy ones. It seems that when the .csv file is converted to an Excel file, the row height is set to over 60 pts. Once we clear all formatting or change the row height to 12 pt, it then works OK. Are you able to shed any light on this, or at least direct me to where I should go to find this information?

Requires Free Membership to View

Can you look at an alternative method to merging? DDE runs through passing messages between the two applications. Since you have a long-running merge, the message passing looks like its timing out. It might be better if you write a VBA macro to do the merging work.

This was first published in June 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: