XL range copied into Word
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 |
XL range copied into Word
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 "Francis Hookham" wrote: 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 |
XL range copied into Word
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 "Francis Hookham" wrote in message ... 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 |
All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com