Open Microsoft Excel and click the Developers tab. Click the Visual Basic icon to open the VBA editor. Click the "Tools" link on the VBA editor menu bar.

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. If you are like ...

First, open the Word app and then import the input Word document from which you want to extract all email addresses. Now, launch the VBA Editor using the Alt + F11 key combination.