We should not have to use 'work arounds' to try to establish the format of
dates and times. Please return to the programming in Word 2000. Instead of
having Word only read "raw" data, let it use the formats we set in the data
doc.

Sign me,
Frequently Perturbed with the changes in Word

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

You don't have to use work arounds, just use the method of connection to the
data source (DDE) that was used in earlier versions. To use that option, on
the General tab of the ToolsOptions dialog, check the box against Confirm
conversions at open.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ARY" wrote in message
...
We should not have to use 'work arounds' to try to establish the format of
dates and times. Please return to the programming in Word 2000. Instead
of
having Word only read "raw" data, let it use the formats we set in the
data
doc.

Sign me,
Frequently Perturbed with the changes in Word

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

Fits my definition of a work around. Something that was seamless in prior
versions and now requires special settings.

"Doug Robbins - Word MVP" wrote:

You don't have to use work arounds, just use the method of connection to the
data source (DDE) that was used in earlier versions. To use that option, on
the General tab of the ToolsOptions dialog, check the box against Confirm
conversions at open.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ARY" wrote in message
...
We should not have to use 'work arounds' to try to establish the format of
dates and times. Please return to the programming in Word 2000. Instead
of
having Word only read "raw" data, let it use the formats we set in the
data
doc.

Sign me,
Frequently Perturbed with the changes in Word

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds

I must say that I agree with ARY. Considering that Office is billed as an
"Office System" these days and is quite expensive, its components should
work together as seamlessly as possible without the user having to take
special actions. All the information available to DDE must be retrievable
from the .xls (or Excel would not be able to recover it), so there's no
reason in principle why the OLEDB provider should not be able to access it.
In so many cases, you have to choose one connection method to achieve one
thing, and another to achieve another thing. For example, DDE gets you the
"data as displayed", but can only access the last-opened sheet. OLEDB lets
you get any sheet, but only the "underlying" data. There are similar "one
connection method does one thing, another does another" problems with both
Access and Outlook as data sources. Another problem with DDE is that it
requires you to have a copy of the orginating application. It also
complicates the whole interaction unnecessarily because the application has
to be opened, not just the underlying data file.

Just my 2c worth

Peter Jamieson

"Doug Robbins - Word MVP" wrote in message
...
You don't have to use work arounds, just use the method of connection to
the data source (DDE) that was used in earlier versions. To use that
option, on the General tab of the ToolsOptions dialog, check the box
against Confirm conversions at open.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ARY" wrote in message
...
We should not have to use 'work arounds' to try to establish the format
of
dates and times. Please return to the programming in Word 2000. Instead
of
having Word only read "raw" data, let it use the formats we set in the
data
doc.

Sign me,
Frequently Perturbed with the changes in Word

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...merge.fi elds