One of the next things to decide is how the user will interact with Word and Excel in our system. I decided that the Excel workbook would be updated independently and Excel wouldn't be started as an application while editing the Word document. The numbers from the Excel workbook are simply extracted and inserted into the Word document using VBA programming.
Another "user interface" issue is where to place the VBA code and how to present controls to the user. It's quite possible to place the controls (command buttons, listboxes) directly into the Word document rather than adding a Windows form and placing them on a form as we will do in this example. Placing controls directly into a document can work very well for a lot of applications but it just creates difficulties in our system. And, in general, you gain a lot of flexibility by using a form to contain your controls. I'll cover this again when we look at the actual VBA code.

I decided to implement the system by displaying a Windows form along with the Word document when the document is opened. This design decision tells me where at least some of the VBA code will have to be: in the Open event for the Word document. The rest of the VBA code is in the Windows form. Here's the display in the VBA editor of the finished system:
Next page >
The Word Document VBA Code > Page
1,
2,
3,
4
5,
6