Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-08-2016, 03:50 AM
blackarrow blackarrow is offline How to connect Word with Excel? Windows 7 64bit How to connect Word with Excel? Office 2007
Novice
How to connect Word with Excel?
 
Join Date: May 2016
Posts: 19
blackarrow is on a distinguished road
Default How to connect Word with Excel?

Is is possible to make some kind of connection between Excel and Word in terms of copying text?



For example, I have a list in Excel, and in cells A1, A3 and A5 I do have some text. I would like to assign some "codes" to these cells, so when I open a Word document, I could easily type these "codes" and the text will be transferred from Excel to Word. The "codes" could simple be numbers 1, 2, 3 etc. so I could open Word, type 1 (and some additional buttons) and get the text from Excel.

I remember that there is a possibility in Word to make text blocks using F3 key, but I am not sure how could I use it in this situation. My wish is to automatically make a transfer, since the text I already have in Excel is not typed by me - it is automatically put in by another program (the Excel document is just an output file).

Thank you very much.
Reply With Quote
  #2  
Old 08-08-2016, 04:43 AM
gmayor's Avatar
gmayor gmayor is offline How to connect Word with Excel? Windows 10 How to connect Word with Excel? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I would create a userform to select the entries from Excel using a combobox or list box - see http://www.gmayor.com/Userform_ComboBox.html. Add bookmarks, content controls or docvariable fields to take the selected output from the userform - http://www.gmayor.com/Userform.htm
__________________
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
Cannot connect alexk2oo Outlook 0 10-16-2013 03:43 AM
Word 2007 can't connect and publish to WordPress Danielm Word 0 10-23-2012 12:38 AM
How to connect Word with Excel? Won't connect to Yahoo WildBill Outlook 1 09-09-2011 04:10 PM
Word crashes trying to connect to printer raymondvillain Word 0 01-15-2009 08:11 PM
cannot connect to isp mail Bob8 Outlook 0 01-15-2006 09:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 PM.


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