Microsoft Office Forums Copy CELLs from XLS to DOC with variables (like DDE)

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2019, 03:36 PM
Fastarrow Fastarrow is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 7 64bit Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Novice
Copy CELLs from XLS to DOC with variables (like DDE)
 
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
  #2  
Old 07-21-2019, 08:05 PM
gmayor's Avatar
gmayor gmayor is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 10 Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,906
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

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
Reply With Quote
  #3  
Old 07-22-2019, 01:06 AM
Fastarrow Fastarrow is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 7 64bit Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Novice
Copy CELLs from XLS to DOC with variables (like DDE)
 
Join Date: Jul 2019
Posts: 4
Fastarrow is on a distinguished road
Default

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!

Quote:
Originally Posted by gmayor View Post
Replace the links in the document with Copy and Paste Special > Unformatted Text with the Link option checked.
Reply With Quote
  #4  
Old 07-27-2019, 08:49 AM
Fastarrow Fastarrow is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 7 64bit Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Novice
Copy CELLs from XLS to DOC with variables (like DDE)
 
Join Date: Jul 2019
Posts: 4
Fastarrow is on a distinguished road
Default

Nobody else knows???
Reply With Quote
  #5  
Old 07-27-2019, 04:03 PM
Guessed's Avatar
Guessed Guessed is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 10 Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,261
Guessed has a spectacular aura aboutGuessed has a spectacular aura aboutGuessed has a spectacular aura about
Default

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
Reply With Quote
  #6  
Old 07-28-2019, 12:56 PM
Fastarrow Fastarrow is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 7 64bit Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Novice
Copy CELLs from XLS to DOC with variables (like DDE)
 
Join Date: Jul 2019
Posts: 4
Fastarrow is on a distinguished road
Default

Here is what I can see. Here is paste options
There are just TWO options with the link! Without link is ok, but there is not a link so it doesnt work when I change in xls value.



please see picture below
IMG
Reply With Quote
  #7  
Old 07-28-2019, 08:46 PM
gmayor's Avatar
gmayor gmayor is offline Copy CELLs from XLS to DOC with variables (like DDE) Windows 10 Copy CELLs from XLS to DOC with variables (like DDE) Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,906
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

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


All times are GMT -7. The time now is 10:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft