#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
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 |
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 |