DDE From Word to Excel

[fearortheson]

I have a form that I have to fill out. I then have to transfer only some of
the fields into an Excel worksheet. Rather than save as data only or re-type
the data into Excel, I have been trying to set-up a DDE between the 2.

However, I am having trouble establishing the link. It gives me an error
saying that the "System" topic is unavailable, then opens Excel and gives me
an error.

Is there an easy way to export selected fields in Word to selected cells in
Excel?

 

[Cindy M.]

Hi =?Utf-8?B?ZmVhcm9ydGhlc29u?=,

I have a form that I have to fill out. I then have to transfer only some of
the fields into an Excel worksheet. Rather than save as data only or re-type
the data into Excel, I have been trying to set-up a DDE between the 2.

However, I am having trouble establishing the link. It gives me an error
saying that the "System" topic is unavailable, then opens Excel and gives me
an error.

Is there an easy way to export selected fields in Word to selected cells in
Excel?

You can automate Excel using OLE, or you could possibly write the data into the
closed Excel file using OLEDB if the file is set up like a database. Here's a
link to get you started with the first. It's basically what you're trying to do
with DDE, but much more "modern" and reliable

http://word.mvps.org/faqs/interdev/controlxlfromword.htm

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail