copy worksheet from excel to word document

[KAPearson]

Hi, I'm trying to copy parts of a worksheet from excel 2003 to word 2003. I've found code that does this alright but I need to be able to re-size the the pasted data to fit the word document. Is there a way to set the properties of the word document like change it to landscape and move the margins etc? Even a simple "reduce the table size to fit the word document" would help. I've included the code i've got already in case it's useful to anyone. This code will open up a word document and copy your cells into it but without any useful options. So its ok for a small group of cells.

Please Login or Register  to view this content.

[KAPearson]

Looking around I've found you can run a macro in word just like excel. So I was wondering is it possible to get excel to carry out the macro in the word document.