XL range copied into Word

[Francis Hookham]

I regularly copy a range from an XL spreadsheet into a Word document by hand
but I should like to automate this if possible

Initial recording selecting a range in spreadsheet, opening a blank Word
document and pasting did not show much promise

Any Suggestions?

Francis Hookham

 

[Jay]

Hi Francis -
Copy the excel source range, switch to Word, choose Edit, PasteSpecial....
The dialog box that opens will give you some options. For starters, choose
"Microsoft Office Excel Worksheet Object." Then, and most importantly for
your application, choose the "PasteLink" radio button on the left side of the
dialog box.

Any changes to the excel document will be reflected in the newly pasted
range in the Word document.

Good luck,
Jay

 

[Ed]

Hi, Francis. How do you want the spreadsheet range to show up in Word? As
a Word table? As a linked item, where clicking on it opens that workbook
for editing in Excel? Or as a graphic, un-editable representation of your
Excel table? One thing to keep in mind - the transition between the two
programs does not like merged cells very much, and will affect how a Word
table will look.

Ed