Hello All & Gretings.

I have a worksheet with several columns and I use 'landscape' orientation to
print it out. Now, I want to include this in a Word document, as an appendix.
I would like to have the worksheet at the end of the document, in a landscape
orientation.

Can someone please tell me how-to do this / provide links / examples, please.

Thanks!

kishan

In Word, go to Insert, Object, Create From File, enter the name of your
file, and there it is. After the worksheet is put into Word, you can
double click it to open it and reformat or change the info.


--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=554261

At the end of the Word document, insert a next page section break. Click
INSERT on the menu and select BREAK, in the list of break types, locate the
SECTION BREAK NEXT PAGE option button and click.

Then format that section for landscape by clicking FILE in the menu, and
selectin PAGE SETUP. If necessary, click the MARGINS tab and then change the
page orientation to landscape and make certain that the APPLY TO combo box in
the PREVIEW panel of the MARGINS tab is set to THIS SECTION. click OK to
exit.

With your insertion point on your newly sectioned landscape page, click
INSERT on the menu and select OBJECT. In the displayed dialog box, click the
CREATE FROM FILE tab, click the BROWSE button and locate your Excel file.
Click the LINK TO FILE check box if you want changes to the workbook
automatically displayed in the Word document. Click OK to insert the file.

For additional information I suggest you peruse Word Help.

--
Kevin Backmann


"Kishanb" wrote:

Hello All & Gretings.

I have a worksheet with several columns and I use 'landscape' orientation to
print it out. Now, I want to include this in a Word document, as an appendix.
I would like to have the worksheet at the end of the document, in a landscape
orientation.

Can someone please tell me how-to do this / provide links / examples, please.

Thanks!

kishan

Hi Kevin:

Thanks for the info. Now, Iam able to get the worksheet into my file ... but
not the landscape orientation! I was very careful to follow your advise about
having this orientation only for the inserted worksheet. Still no luk.

Also, even though, the worksheet is appearing, the right-side columns are
all gone- doesn't fit too well within the page. SO I am still working on the
same and look for any suggestions.

Thanks,

kishan