I have a workbook, that has multiple worksheets.

each worksheet is a form, with identical layout, but different data.
Each page is formatted to print A4 fit to page.

Is it possible to convert the workbook to a word document, with each
worksheet as a seperate page in the word file.

Thanks, in anticipation...

SS

I would suggest this might be better posted in a Word group.

You cannot "convert" an Excel workbook to a Word document.

AFAIK you would have to copy one sheet at a time into pages of a Word document
but someone over in a Word group probably has a method.

Or you may be able to build your form in Word then use mailmerge to pull the
data from Excel.


Gord Dibben MS Excel MVP


On Tue, 5 Feb 2008 20:05:59 -0000, "simon steel" <(E-Mail Removed)> wrote:

>
>I have a workbook, that has multiple worksheets.
>
>each worksheet is a form, with identical layout, but different data.
>Each page is formatted to print A4 fit to page.
>
>Is it possible to convert the workbook to a word document, with each
>worksheet as a seperate page in the word file.
>
>Thanks, in anticipation...
>
>SS
>