Print all the worksheets in an embedded Excel workbook

[dave.cuthill]

I'm not sure if this is a vba question but ...

Is there a way from within word that you can print the word document
plus all the worksheets from an embedded excel workbook?

David

 

[Cindy M -WordMVP-]

Is there a way from within word that you can print the word document

plus all the worksheets from an embedded excel workbook?

Might be VBA, then again...

Do you mean print them independently of the Word document? As in open
them in the Excel application and print them?

Yes, it can be done using VBA.

If you mean, just everything, then please explain how clicking the
"Print" button in the Word toolbar is NOT working.

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

 

[dave.cuthill]

Using the print button in word prints the word document plus the
displayed worksheet of the embedded spreadsheet but I want to have all
the sheets in the workbook print. I figured out that I could control
excel from word to print the complete spreadsheet but which was
basically equivalent to opening excel from word and then selecting the
corresponding workbook to print. This works okay but the document and
workbook are not linked.

My preferred method would be link the workbook to the document and then
at the time of printing have word print all sheets in the workbook.

David