![]() |
|
#1
|
|||
|
|||
![]()
Hello,
I am using office 2010 Professional. Basically what I would like to do is insert certain data from a word document into an excel cell. For example if I type the word Example1 into word (possibly in a table) then that is inserted into a specific cell in my spread sheet. (there is a specific need for this) unfortunately it is not as simple as just bypassing word and typing it straight into excel. ![]() |
#2
|
||||
|
||||
![]()
Hi elemental,
If you type something into your Word document, then copy it and choose 'paste link' in Excel, Word will create an OLE_LINK bookmark spanning that range, and the data between the document and workbook will be linked. If you edit the bookmarked range in Word (without deleting the bookmark), the Excel workbook's contents will update to reflect the change. The bookmarked range can include a table, in which case, the whole table will be linked and you can edit the individual cells.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jaymond Flurrie | Word VBA | 2 | 02-27-2011 07:42 PM |
![]() |
markg2 | Word | 1 | 12-15-2010 12:19 PM |
![]() |
tareq | Excel | 12 | 09-29-2010 02:12 PM |
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file | buggingme | Office | 1 | 05-30-2010 12:18 AM |
Automate Data from Excel into Word DropDown...? | sigraves | Word VBA | 0 | 08-03-2009 06:54 AM |