How to Open a Word Document From Excel Using VBA. Millions of small businesses all around the world use Microsoft Word and Excel daily to create correspondence or crunch numbers.

How to use the VBA procedure in Word As you can see in Figure D, the demonstration file comprises two pages and each page has two Word fields, {PAGE} and {NUMPAGES}.

VBA and Security Concerns Keep in mind that if you write code in VBA and embed it in an Excel or Word file, the file will get a distinct extension indicating that it contains macro code.

Save the file and return to the Word document. You’re ready to run the VBA procedure to see how it works. How to run the VBA procedure in Word Now comes the easy part: Running the procedure.

Microsoft Word can accommodate a surprising number of file formats, and even take in Excel and PowerPoint data, though it might look funny. Here's how.