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.

Vba copy word table to excel