#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default insert doc to xls

HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default insert doc to xls

Insert - Object - create from file

Same process either way

"VISHNU60IN" wrote:

HOW TO INSERT A EXCEL FILE INTO WORD & VICE VAERSA?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server -- Bulk Insert from Excel to SQL Server Madhan Excel Discussion (Misc queries) 0 December 12th 06 03:08 PM
Changing the Insert Row / Column Default Mr. Low Excel Discussion (Misc queries) 4 October 23rd 06 05:25 PM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 06:37 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"