Problem solve Get help with specific problems with your technologies, process and projects.

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?
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.

Dig Deeper on Windows Server storage management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.