I have an excel 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
If you download and install the old Excel converter from my we site and the workbook is in xls (compatibility format) rather than 2007 xlsx format, then you can import the whole workbook into Word. It does not however place each sheet as a new page, but places them immediately one after the other. How this would automatically format to your document depends on the margins. You may need to do some reformatting. Furthermore none of the Excel formatting is retained. For that you would need to insert the individual sheets into your document. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> simon steel wrote: > I have an excel 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
