How can I copy Excel sheets w/footers into Word.

[Guest]

Today I had to present a document made from a 6 page word document, 2 tabs of
an Excel spreadsheet, 3 graphs from another spreadsheet and 4 graphs from a
3rd spreadsheet. In the future I would like to eliminate hand collating. I
needed 25 copies of the document. When I copy and paste I do not get the the
header and footer from the spreadsheets.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SmltIENhbXBiZWxsIGluIERlYXJib3Ju?=,

Today I had to present a document made from a 6 page word document, 2 tabs of
an Excel spreadsheet, 3 graphs from another spreadsheet and 4 graphs from a
3rd spreadsheet. In the future I would like to eliminate hand collating. I
needed 25 copies of the document. When I copy and paste I do not get the the
header and footer from the spreadsheets.

There is no way to automatically import the header/footer information from Excel
into a Word document.

If you have the Office 2000 (or 97) CDs/disks around, you can install the
Microsoft Binder and use that. If you have Office 2002 or 2003 you also need to
be sure the Binder support is installed for that version.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail