Array from Excel to Word

[business_analyst]

Hello All,

So I'm trying to send some information from Excel to Word. The steps for this seem to be easy enough and I've gotten everything to run pretty smoothly. Now, I would like to try and fill a table in word with an ARRAY from Excel. Is this even possible? Or would it be more advised to print the array to a worksheet and then send that to Word as a table? Any tips on how to go about doing this would be greatly appreciated, thanks.

 

[TinaP]

Have you investigated the object linking and embedding in Word? You can insert an Excel worksheet into your Word document and have almost full Excel functionality while still residing in Word. I have Office 2007, so you'll have to translate if you have a different version.


If you want to create it from scratch:

1. From the Insert tab, click Object.
2. Select the Create New tab.
3. Select Microsoft Office Excel Worksheet.
4. Click OK.
5. Work as if you are already in Excel.

If you already have the data in a file:

1. From the Insert tab, click Object.
2. Select the Create from File tab.
3. Enter the path and filename (or browse).
4. If you want the data in the Word document to change every time you update the data in the original file, check Link to file; otherwise, leave it unchecked.
5. Click OK