Word - using Ecxel - how to add data from within Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kaypee - 03 Mar 2005 09:57 GMT

TIA

Have a document which has an excel spreadsheet as a datasource. Is it
possible to add to that datasource from within Word. While working on the
main document - or do I have to manually open the data source.

Kaypee

Reply to this Message

Peter Jamieson - 09 Mar 2005 10:45 GMT

On the whole, Word either opens the spreadsheet by using DDE to open Excel,
which opens the spreadsheet, in which case you should probably edit the data
directly in Excel, or by opening Excel using OLEDB, in which case the Edit
button in the Edit recipients dialog box is generally greyed out and you
can't edit directly.

Peter Jamieson

> TIA
>
[quoted text clipped - 3 lines]
>
> Kaypee

Reply to this Message

Simon, HK - 11 May 2005 07:46 GMT

How to set it to use DDE to open Excel?

> On the whole, Word either opens the spreadsheet by using DDE to open Excel,
> which opens the spreadsheet, in which case you should probably edit the data
[quoted text clipped - 11 lines]
> >
> > Kaypee

Reply to this Message

Peter Jamieson - 20 May 2005 10:56 GMT

Check Word Tools|Options|General|"Confirm conversion at open" then go
through the connection process again and select the DDE option when it is
offered.

Sorry for the late reply.

Peter Jamieson

> How to set it to use DDE to open Excel?
>
[quoted text clipped - 17 lines]
>> >
>> > Kaypee

Reply to this Message

Simon, HK - 23 May 2005 05:04 GMT

Thanks Peter, it works! ^_^

> Check Word Tools|Options|General|"Confirm conversion at open" then go
> through the connection process again and select the DDE option when it is
[quoted text clipped - 25 lines]
> >> >
> >> > Kaypee

Reply to this Message