Template:='Normal', NewTemplate:= False, DocumentType:=0 'In VBE Editor Tools -> References -> Microsoft Word x.xx Object Library 'Remember to set the reference to the Word Object Library Sub CreateWordDocument() 'Connect using Early Binding.

Often, Selecting and Activating Objects is not required in VBA code, so I have not copied those statements into the code below. The Word VBA code started with Documents.Add, all we have to do is add our application variable to the front of that line of code. Now copy and paste the code from the Word VBA Editor into the Excel VBA Editor.

Let’s head back to the Excel VBA Editor and use the Early Binding method to control to Microsoft Word. In the Visual Basic Editor click Tools -> References select Microsoft Word x.xx Object Library. Then click OK.Īs we are using Early Binding we need to declare the Application as a variable as follows: Dim WordApp As Word.Application Sub Macro1()ĭocuments.Add Template:='Normal', NewTemplate:= False, DocumentType:=0Įnd Sub Add the code to Excel VBA and amend Your code should look like the following. It may be slightly different, but not significantly. In this example: Normal -> Modules -> NewMacros. Click: Developer -> Visual Basic.įind the location of your recorded code in the Visual Basic Editor. We can now view the code for opening a new Word Document in the Visual Basic Editor. Stop the Macro from recording – Developer -> Stop Recording Open a new Word Document – File -> New -> Blank Document Normal.dotm is fine for now. Click OK – the Macro Recorder is now running.

Make a note of the “Store macro in” option, as we will need to know where to find the recorded code later. The key to the success of this method is taking small sections of code and building up a complex macro bit by bit. Using the Word Macro Recorder is again, similar to the Excel Macro recorder.įor the example in this post, we will create a macro which will open a new Word document, then copy a chart from Excel and paste it into that Word document. We will tackle this one stage at a time. Firstly, lets create the macro to open a new word document.Ĭlick – Developer -> Record Macro. The Record Macro window will open.

Then tick the Developer Ribbon option, OK. In Word: File -> Options -> Customize Ribbon If you have enabled the Excel Developer menu it is the same process in Word. Repeat the previous steps until macro complete.

Copy word table to excel using macro