First you must reference the Word object library. In the VBA development window, select Tools, References, then look for "Microsoft Word x.0 Object Library" in the list, where x is whatever version of Word is in there. Then you can run the following code:
This assumes the Word doc is not already open. It will generally paste this at the beginning of the document. You do not say how you want this pasted. My example pastes it just as if you simply did a manual Paste. That is, you will get a Word table that is formatted like the Excel cells. The Word document is left open.
Also, see my signature for instructions on code tags, which are required by the rules.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Bookmarks