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
|