VBA in Word to populate word document from excel data file.


New Member
Jul 19, 2019
I am looking for a way to extract excel data into a word document, from the VBA in the word document. There is one cell in the excel file that is either empty or contains data that needs to be split so for example:

Excel Data

Cell1 Cell2 Cell3 Cell4
Yes Yes No Yes|No|Maybe|Not Required

In Word doc after import

Cell1 value is: Yes
Cell2 value is: Yes
Cell3 value is: No

Cell4 Part1 is: Yes
Cell4 Part2 is: No
Cell4 Part3 is: Maybe
Cell4 Part4 is: Not required

Then repeat for all other rows in the excel data file.

I don't think this can be achieved using mail merge because of the data in cell4

Appreciate any suggestions on how this can be done.

Thanks in advance

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...