Novice needs code(?) to print Excel worksheet from within Word.

[LacieMoon]

I have a series of documents (Word and Excel) that are used to create an "end
user" PDF informational package; this PDF is sent via email. I am trying to
streamline the process -- Is there any way I can program Word to print an
Excel Worksheet *in its final scaled size* and INSERT it within a Word
Document print process?

I use Adobe "distiller" to create PDF files during the print process. In
order to maintain format and page numbering I'd like to print the first 2
pages of the Word Document, embed/link/or? the Excel Worksheet (scaled to fit
on one page) then print the rest of the Word Document pages. Of course, the
"print" really is a complete PDF file. I'm sure you'll likely need more
details because I'm not sure how to describe this in 'developer' terms.

Thanks for any suggestions!
LacieMoon
OS: Windows XP
Office: Office XP (SP3)
I do not know VBA - but I can follow directions!

 

[Cindy M -WordMVP-]

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

As far as I know, there's no way to ensure that an Excel sheet embedded or
inserted into a Word document will be any particular size. Word will adjust what
comes in to fit the page/margins.

You might have better luck using the old Office 2000 BINDER application.

I have a series of documents (Word and Excel) that are used to create an "end
user" PDF informational package; this PDF is sent via email. I am trying to
streamline the process -- Is there any way I can program Word to print an
Excel Worksheet *in its final scaled size* and INSERT it within a Word
Document print process?

I use Adobe "distiller" to create PDF files during the print process. In
order to maintain format and page numbering I'd like to print the first 2
pages of the Word Document, embed/link/or? the Excel Worksheet (scaled to fit
on one page) then print the rest of the Word Document pages. Of course, the
"print" really is a complete PDF file. I'm sure you'll likely need more
details because I'm not sure how to describe this in 'developer' terms.

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