I got great advice on my previous Excel post and I need one more step.
I have multiple worksheets that I need to insert into a Word doc. These sheets are just some of the sheets in the workbook. I have 65 sheets to insert, so I don’t want to do this sheet by sheet. So far the only way I have found is to select the desired sheets and create a PDF file. Then I have to get that file into Word. Possible, but not easy.
I can’t use links as our company security policy prohibits the use of linked documents.
Most of the tricks I found on the net involve converting the pages to images and inserting those. I guess I could, but is seems really tacky to do that. Besides, I need to keep the file size small enought to email the document.
I need a bulk way to do this, I can’t take the time to insert each page individually. The whole point of doing this is to speed things up.
thanks in advance