When I have the document protected it won’t let the user insert an object into the document. How to Insert Excel Data into Word Like Tables, Files, and Spreadsheets. For the most part it comes in to Word great, but since it spans several pages, I like to have the top line or lines 'repeat as header' lines on each page. Open Microsoft Excel or whichever spreadsheet software you use. Select the cell into which you want to insert your file. You can create a text box in excel, and then select all text in the word document (Ctrl-A), copy it and paste i. Say, you have a workbook with three sheets. The PDF document appears as an icon on the Excel Workbook. I have a multi-page (30+) spreadsheet that I want to add to a Word document. In Microsoft Word, place the cursor where you want to insert the data table. The downside is the entire table is broken up, but it fits on each page doing it this way. Since we’re creating mailing labels, the data we will be merging will be first name, last name, and address. There is a feature in my application which allows the user to export the tabular data into excel. graphic file of each page for import into PPT or print to MODI as TIFFs then. You'll need to make screenshots of each page or print to PDF then export a.
The problem is that your xlRange isn't text. As well I need the rich text formating to carry over into the Word Document. One of my tabular data contains word document.
