Convert from excel to word - can this be done?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simon steel - 05 Feb 2008 20:05 GMT

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

Reply to this Message

Gord Dibben - 05 Feb 2008 21:08 GMT

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

>I have a workbook, that has multiple worksheets.
>
[quoted text clipped - 7 lines]
>
>SS

Reply to this Message