Combine Word with Excel Seamlessly

[Glazed]

Suppose I have one worksheet in one workbook of an Excel file, that prints a
table on one page, in landscape format. And suppose there are Excel headers
and footers that cannot be seen in the worksheet cells but show up on the
printout. Also, suppose the file is printed 75% its normal size.

Now, suppose I have a Word file with one page with simple text. It prints
out in portrait format. The margins are in no way related to the Excel file.
The size is 100%.

What I want is to bind these files together into one file or object so that
I can open this one file, and see the Word document on page 1, the Excel
document on page 2. Yet I want to be able to edit each independenlty as if
they didn't know they were joined together, as if they were sepearate
creatures. Also, when I go to print preview, I want page 1 to print the Word
file the same exact way it printed as a stand alone file, and the same thing
with the Excel file on page 2. Page 1 should be 100% in portrait format with
its own margin lengths, and page 2 should be 75% in landscape format with ALL
its headers and footers displayed, exactly as it would be if I had printed
them in Excel as a stand alone file.

I don't want to have a word file with the Excel file embedded in it or a
link to the Excel file in it, since I'd have to print twice. I don't want to
insert the Excel cells as a table, since I'll lose the headers and footers. I
want the sizes to be perect. If the Excel file looks one way on the printed
page, then when combined with the Word file it should look exactly the same.
I don't want to refortmat or resize anything. Each piece is perfect, and I
want them as is!

Of course, personally, I don't mind printing two files. But users of my
reports like tables to be part of the report, in one file. They don't want a
Word file and then and Excel file, they don't want embedding (I'd prefer just
one big website, but my users are old-fashioned, they want a printout). As
Excel files, my tables are perfect. Mating them with Word messes it all up.
The other option is to create Word tables, but that is simply sadistic! It is
so much harder than Excel!

 

[Shauna Kelly]

Hi

If you have Office 2000 or earlier, you have the Office Binder product. Try
Start > Programs > Microsoft Office > etc to see if you can find it. It was
designed to do exactly what you want.

However, Binder was killed off with Office XP (ie Word 2002 and Excel 2002).
If you have Word 2002 or 2003, and you still have a copy of Office 2000
around, then you can still use the old Binder program.

If you don't have Binder, then my best suggestion is the following. Do away
with the headers and footers in Excel. Put that material in rows in the
spreadsheet. Copy the relevant range, then, in Word, do Edit > Paste Special
and paste as a picture. If you want to avoid having two files to update,
then link the picture so that it will change whenever the Excel file
changes.

Pasting as a picture has several advantages. You can control the size
exactly; you don't have the sadistic pleasure of dealing with large Word
tables; it avoids users messing with the Excel tables; and it cuts down on
file size.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word