Excel to Word

Mar 12th, 2002, 12:33 PM

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 · Mar 12th, 2002, 07:25 PM

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

Mar 12th, 2002, 10:50 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 12:33 PM	#1
Guest Posts: n/a	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.

Mar 12th, 2002, 07:25 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Could you just insert and excel worksheet in your word doc?

Mar 12th, 2002, 10:50 PM	#3
Guest Posts: n/a	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.