Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Excel 2003 Workbook into Word 2003

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Excel 2003 Workbook into Word 2003

I just tried it out and got a multi-tab workbook to show up in Word 2003.

Here's what I did:

1) Insert--Object

2) Select "Create from File" tab

3) Navigate to the .xls document

4) Click OK.

Is that what you're looking for?

Dave

--
Brevity is the soul of wit.


"B. Levien" wrote:

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Excel 2003 Workbook into Word 2003

Yes, that's what I mean, but if I do the same thing, I only get the first tab
.... I don't get any of the others.

"Dave F" wrote:

I just tried it out and got a multi-tab workbook to show up in Word 2003.

Here's what I did:

1) Insert--Object

2) Select "Create from File" tab

3) Navigate to the .xls document

4) Click OK.

Is that what you're looking for?

Dave

--
Brevity is the soul of wit.


"B. Levien" wrote:

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Excel 2003 Workbook into Word 2003

Double click on your embedded Excel object and then select the tab you want
to display.
--
Kevin Backmann


"B. Levien" wrote:

Yes, that's what I mean, but if I do the same thing, I only get the first tab
... I don't get any of the others.

"Dave F" wrote:

I just tried it out and got a multi-tab workbook to show up in Word 2003.

Here's what I did:

1) Insert--Object

2) Select "Create from File" tab

3) Navigate to the .xls document

4) Click OK.

Is that what you're looking for?

Dave

--
Brevity is the soul of wit.


"B. Levien" wrote:

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Excel 2003 Workbook into Word 2003

Thank you very much! I was NOT aware that you could access the other sheets
(which will actually be quite helpful in future situations, unfortunately not
in this one).

What I was looking for was a way to import an entire workbook, but have each
worksheet import onto a different page.

I think the Edit/Copy picture will have to do for this instance.

Thanks again for the very quick reply!

Brenda

"Kevin B" wrote:

Double click on your embedded Excel object and then select the tab you want
to display.
--
Kevin Backmann


"B. Levien" wrote:

Yes, that's what I mean, but if I do the same thing, I only get the first tab
... I don't get any of the others.

"Dave F" wrote:

I just tried it out and got a multi-tab workbook to show up in Word 2003.

Here's what I did:

1) Insert--Object

2) Select "Create from File" tab

3) Navigate to the .xls document

4) Click OK.

Is that what you're looking for?

Dave

--
Brevity is the soul of wit.


"B. Levien" wrote:

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.

If I go into Word, and choose Insert/File, and find my Excel Workbook, I get
pages of garbage.

Are both of these behaviours normal for Excel and Word 2003? Is there any
way I can insert a Workbook (with multiple Worksheets) into a Word document
as separate pages?

I did end up selecting the area in each Excel Worksheet within the Workbook,
holding down the SHFT key down and choosing Edit/Copy Picture and pasting
into Word, but I'm curious to see if there's an easier way to get the entire
workbook in a Word document in one fell swoop.

Thanks.

Brenda



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
Can I just convert to Word 2003 and Excel 2003? Curious Excel Discussion (Misc queries) 0 February 11th 06 04:42 AM
Saving a workbook in Excel 2003 serge Excel Discussion (Misc queries) 0 February 9th 06 05:26 PM
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 03:30 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Add a word document to an Excel workbook ddzahn Excel Discussion (Misc queries) 0 April 12th 05 10:12 PM


All times are GMT +1. The time now is 08:39 AM.

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

About Us

"It's about Microsoft Excel"