how to print whole excel workbook in msword

[gsrikanth]

how to print whole excel workbook in msword
while printing with excel workbook sheet also print

[macropod]

You can't print what you can't show, and Word will only show, at most, however much of a single worksheet that will fit on a single page.

The only way around that would be to use a macro to open the workbook and print it from Excel.

[gsrikanth]

i need that macro sir

[macropod]

Try the following macro. It assumes the Excel workbook is the first inlineshape in the document. If it isn't inline or isn't the first, adjust the code to suit. The entire visible worksheet will be printed, using whatever page setup you have already defined for it.

Please Login or Register  to view this content.

[satputenandkumar0]

It is not possible to print the whole workboon in ms word, you can copy all it in Ms word and print from there.

Regards,
Nandkumar Satpute

------------------------------------------------------------------------------------------
CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

[macropod]

I find it interesting that people who obviously haven't tried the solution I posted keep saying it can't be done.