Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My charts are copied into Word in black and white instead of colou | Excel Discussion (Misc queries) | |||
Excel Financial Statements Copied into Word - No Underlines when p | Charts and Charting in Excel | |||
Copied range from excel to word (but not in table-form) | Excel Programming | |||
Excel Object copied to Word not printing in color | Excel Discussion (Misc queries) | |||
problems with charts copied into Word 2000 | Excel Discussion (Misc queries) |