#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Replace the links in the document with Copy and Paste Special > Unformatted Text with the Link option checked.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thank you mate,
I have just two options how to paste WITH the Link option. With format from source, or merge format. I dont have Unformated with the link option. WHere can I find unformated with the link option? Thanks a lot! |
#4
|
|||
|
|||
Nobody else knows???
|
#5
|
||||
|
||||
George
It sounds like you are doing a paste and then looking at the pop-up options rather than doing a Paste Special. The Paste Special options that Graham suggested can be found by using the drop down arrow on the first button on the Home ribbon - Paste > Paste Special
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#7
|
||||
|
||||
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy & paste 2 ranges of cells | trevorc | Excel Programming | 14 | 12-02-2018 03:08 PM |
Array to iterate through variables and trap blank variables | Marrick13 | Word VBA | 5 | 08-04-2015 06:19 AM |
Copy data from certain Cells in new sheet | zain_shaikh | Excel Programming | 1 | 02-11-2015 07:35 PM |
can word: make variables, find appropriate pages, fill out pages with variables, print only those | 20GT | Word VBA | 1 | 10-15-2014 09:48 PM |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |