Hi All

I wonder if you can help please, I have some code built in Excel which opens word and copies and pastes some data into a word document. The thing is I need to change the layout in word from portrait to landscape but do not seem to be able to do this, I have used ActiveDocument.PageSetup and the orientation but this seems to come back as an error - any ideas?

Many Thanks