It seems that even without trying to record a macro, I do not get the option to rotate a *linked* image after the paste special.
I want to automate it, but I cannot access the picture properties during a macro record, and I don't know enough about VBA to write the code from scratch.Īn even better solution would be if I could paste special a *linked* range as a picture, then rotate and resize as necessary. But since I need to repeat this on a number of reports, I found that I can accomplish this by copying the range from Excel, then using a Paste Special in Word, and pasting as a picture, then modifying the pasted picture properties to rotate and resize. I do not want to insert a separate landscape On the Header and Footer toolbar, click Link to. Navigate to the page you need to modify (in this example, ).
First, be sure that you have created section breaks (not just simple page breaks) in order to allow for the portrait and landscape pages. Top-left cell in the table would be displayed at the bottom-left of the Word page, with each additional table column showing higher up on the Word page, and table rows extending to the right of the Word page). This article details how to rotate landscape page numbers to match the Portrait layout. The report pages are in portrait orientation, with headers and footers, and I want the table to be displayed in landscape orientation on this page (i.e., I am creating a report template in Word which uses a table developed in a separate Excel document.
