Word Document Merge and MS Excel Worksheet via DDE

[Guest]

When I attempt to use "CONFIRM CONVERSION AT OPEN" and choose my excel
spreadsheet using MS Excel Worksheet via DDE, the worksheet isn't loading in
correctly. Seems as though one of the last columns is loading as the 1st and
pushing certain columns over 1 per the headings of the columns.

Thoughts?

 

[Cindy M -WordMVP-]

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

When I attempt to use "CONFIRM CONVERSION AT OPEN" and choose my excel
spreadsheet using MS Excel Worksheet via DDE, the worksheet isn't loading in
correctly. Seems as though one of the last columns is loading as the 1st and
pushing certain columns over 1 per the headings of the columns.

I assume this is Word 2002 or 2003 and you're looking at the "Recipients" dialog
box? Someone at MS had the bright idea to pre-sort the column list for this
dialog box based on some unfathomable premise. You can drag the columns around
in the opened dialog box, but there's nothing you can do to change how Word
decides to present these columns when the dialog box is opened.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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