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 last published in June 2002

Dig Deeper on Windows File Management

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close