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+

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.

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

  • VDI assessment guide

    Wait! Don't implement VDI technology until you know your goals and needs. A VDI assessment should consider the benefits of a VDI ...

  • Guide to calculating ROI from VDI

    Calculating ROI from VDI requires a solid VDI cost analysis. Consider ROI calculation models, storage costs and more to determine...

  • Keep the cost of VDI storage under control

    Layering, persona management tools and flash arrays help keep virtual desktop users happy and VDI storage costs down.

Close