Question: how to copy and paste from excel to word using vba?
Answer: Open Excel.
Press Alt + F11 to open VBE.
Insert | Module.
Paste the code there.
Tools | References - Check to make sure that "Microsoft Word 10.0" is checked; if not then add the reference (Note that the number 10.0 may be different based on your version of Excel).
Change this line <<Sheets("Sheet1").