View Single Post
 
Old 07-21-2019, 03:36 PM
Fastarrow Fastarrow is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2019
Posts: 4
Fastarrow is on a distinguished road
Default Copy CELLs from XLS to DOC with variables (like DDE)

Hi guys! I need big help, cuz I need fill revision in word document, but on diferent places. So I used DDE object to fill those five items in Excel and it was connected to word so when I chanded in Excel those five cells, then it changed in word and I could just save document without fault.

I used Libbre Office and I used DDE object. (it means copy in excel and paste as DDE) . But then it stopped work. But now I have Office 2016 and there I can copy the same, and the connection between doc and xls would renew, but the value is on self row!! And I need to put it in the middle of text (my electrical revision).

So for example i need:

xls - cell A1 has value "danger"
doc - The building is in "danger" condition.

When I move that field "danger" to that sentense, that is good. But in the next revision when I change value in excel it wil jump tu another row just its own.

xls - cell A1 has value "danger"
doc - The building is in
"danger"
condition.

How to solve my problem please?? This is my solution, mabye exists better one.

Simply: I need change couple words in doc file and source of this change words will be in excel.

Thank you very much for a help and have a good day!
GEORGE
Reply With Quote