Transfering Data

  • Thread starter Thread starter Guest
  • Start date Start date
Copy the Excel cell to the keyboard
In Word with the cursor at the required location, edit > paste special >
check the 'paste link' box and select html format (which should already be
selected). As long as both apps. are open changes you make in Excel will be
reflected in Word. If Word is closed when you make the changes, you can
update the links to reflect the new data.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>


 
Maybe you would be interested in the mail merge features of Word: these
allow you to set up a source template with specific field tages representing
the data from your Excel file. The process is really point-and-click and
does not require any programming. Refer to Word help on this feature for
guidance.
Otherwise you'll probably have to go into programming mode using a template
file with bookmarks in the appropriate location and have VBA extract your
Excel data and paste it at the appropriate bookmark locations.

hth

Robin
 
Back
Top