Sub Macro1()ĭocuments.Add Template:="Normal", NewTemplate:= False, DocumentType:=0Įnd Sub Add the code to Excel VBA and amend It may be slightly different, but not significantly. Your code should look like the following. 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 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. Firstly, lets create the macro to open a new word document.Ĭlick – Developer -> Record Macro.
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. The key to the success of this method is taking small sections of code and building up a complex macro bit by bit. 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. The process I am about to show you may not create the most efficient code, but I know this process works, because I have used it myself to automate lots tasks using Microsoft Word. I am not an Excel VBA expert (I’m more of an Excel VBA tinkerer), and I am certainly not a Word VBA expert.
Repeat the previous steps until macro complete.The process we will use for this is as follows: In this post, we will look at how we can control Word from Excel even though we don’t know any VBA code for Word.
#MICROSOFT WORD MACRO RECORDER HOW TO#
In the first part we looked at the basics of how to reference other applications using Early Binding or Late Binding. This post is the second in a series about controlling other applications from Excel using VBA.
0 kommentar(er)
