Excel to Word

[Guest]

I was able to create a macro that can create multiple word documents from a data set in Excel but the Word documents are not formatted as the spreadsheet template is. i.e the word document is not centered on the page and some of the text is too close to the borders of the cell, not like in the excel template sheet. Help with auto formatting the word document after pasting from excel into word.

 

[Paul B]

Could you just insert and excel worksheet in your word doc?

 

[Guest]

Thanks for the one response, already figured it out. Much simpler than I thought, all I had to do was pastespecial DataType:=wdPasteEnhancedMetafile and it created the word documents ready for printing.