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").