ExcelBanter - insert doc to xls

Vishnu,

Select and Copy the Excel stuff. In Word, put the cursor where you want it,
do Edit - Paste Special -Microsoft Excel Object.

This is called embedding, and there are some things to consider. The entire
Excel file (all worksheets), not just the selected area, are embedded in the
Word file, though you see only the part you'd selected. To view this in
Word doesn't require the user have Excel, but if he does, he can
double-click, it into edit mode, and can view and change any part of the
original workbook file -- any worksheet. This embedded file is a copy of
the original -- it's not linked to the original (unless the link option was
used in the Paste Special dialog), so if the original changes, this doesn't.
It can make the Word file quite a bit larger, since the entire Excel
workbook file is embedded.

The same is generally true for embedding a Word document in Excel.

You may just want to copy the Excel stuff and paste it into the Word
document. That will create a table, and it'll look similar to the Excel
stuff. It will be editable in Word (it's a Word table). It won't include
anything but the selected part of the Excel file.

When pasting Excel stuff into Word, if you use Paste Special, but not
Microsoft Excel Object, but some of the image options (picture, bitmap,
etc.) , it will look exactly like the Excel stuff, but won't be editable --
it's not a Word table in this case.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"VISHNU60IN" wrote in message
...
HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA?