>I am publishing a report in Word. Of course the report orientation is Portrait, with the page number displaying bottom center from a Portrait orientation. Headers would also be on the top, in the same portrait orientation.
>I would like to import several Excel tables that are wider then tall. I would like the table to be oriented landscape on the page, but keep the header and footer in the normal Portrait orientation. Unfortunately, Word is not letting me rotate the imported table. Of course, I could change the orientation in Word for the page with the table, but then the header & footer also shift to the Landscape orientation. It seems I should be able to have just the table rotated to landscape, but keep the pagination, and header information in the portrait orientation, but I can't.

What you're seeing is Word's functionality at work. The only object able to be rotated is a bitmap object. (OK, it's own drawing objects can be rotated, but they're different kinds of objects). Adding insult to injury, Word won't put portrait headers/footers on a landscape page.

Perhaps the solution is to take a bitmap image of the Worksheet. To do this manually in Excel, select the range you want in the bitmap, then hold the Shift key while pressing the Edit menu, and select the Copy to Picture option. Once you select the options, the image is placed on the clipboard, and can then be pasted into Word.

If you are automating the task, then check out the CopyPicture method. This is a method of the Range, Chart, and Shape objects, so you can "take pictures" of all these objects. Then in Word, you'll simply Paste the clipboard at the appropriate point in your document, then use the ShapeRange's IncrementRotation method to rorate the picture.

What you lose in this process is the in-place activation within the Word document, but for most of my clients, they just want to print the image and the in-place activation isn't needed. But you do get to keep the portrait headers/footers and get the landscape look of the Excel spreadsheets.

Hope this helps!
- della

- della