VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
In this tutorial I’m going to show you how to link Excel to Word. This will take your information out of excel and put it into word for you. The first thing you are going to want to do is to make surer that word is selected in the referencing window. To do this in the VBA editor go to tools and then to References.
That will bring up this window, and you want to search through the list until you find Microsoft Word and tick it you might also need to find excel for some reason it was not selected when I done this but it normally should be.
This is the code you will need to use to make the List of names be copied from Excel to Word.
If you run this code in Excel you will get this message box appear.
Now if you open word you should see your names in there just like below.