Copy excel sheets to Word Tables

**oneillp1** · 02-25-2013, 09:59 AM

Any help would be appreciated, I found a macro that works semi-correctly, I need to copy all sheets from a workbook and paste them into ONE word document. The macro that I am using is:

Please Login or Register  to view this content.

This macro works but it makes all the sheets pasted into separate documents and I need them all in the same document.

Thanks for any input.

**OllieB** · 02-25-2013, 10:05 AM

Two things,

One, the forum rules stipulate that you must enclose your code with CODE tags. Please edit your post, select the code and click on the # button.

Secondly, I have looked through the code and all worksheets are copied into the same document as paragraphs. Your statement that all worksheets are copied into separate documents is not something that is supported by the code posted.

**oneillp1** · 02-25-2013, 11:16 AM

Sorry about the CODE tags, this is the first time I am posting to this forum. I realize that the code states that the all sheets are populated into one document, however when I run this code on a Workbook with four sheets, it returns 4 documents.