export data from excel to word

Wonkeytangent

New Member
Can anyone help?

I want to extract data from excel into a table in word. I have looked on google and am now familar with macros however still don't know how to do it.

Cheers
 
No. I have an application that produces information. I want to take this information and have it inserted into a table in a word document. I can not change the format of the word doc. I can make it dynamic but it needs to be printed off and submitted in the format it is in. I believe macros are the answer but need help.

Oh and by the way to get from application to word we can export the data to excel. It is being done elsewhere but I am not able to copy the process
 
Have you tried the following?
  1. Select the cells in excel and then Ctrl. + C to copy them.
  2. Create a table in word with the exact same number of cells as the table from excel.
  3. Highlight all the cells in word. Make sure you click + hold + drag to select the cells. Don't just choose to "select table" because then it won't work. In other words, nothing outside the table borders should be selected. If on the right side of the table, you see that the selection for each row goes a bit outside the table, then it's wrong.
  4. In word, click on Edit - then "paste special".
  5. Select the checkmark for "paste" (not for "paste link").
  6. From the list in the pop-up window, scroll down and select one of the following depending on what you want: either "Formatted Text (RTF)" or "unformatted text" or "unformatted unicode text" and click OK.
Does that work?
 
Last edited:
Back
Top