Q

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.
This was first published in June 2002

Dig deeper on Windows File Management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close