#WORD AND EXCEL FOR FREE HOW TO#
#WORD AND EXCEL FOR FREE CODE#
#WORD AND EXCEL FOR FREE SERIES#

To make the Word document visible I have added the following code: WordApp.Visible = True WordApp.Visible = True 'New Apps will be hidden by default, so make visible Set WordApp = Nothing 'release the memoryĪ point to note, when an application is opened with VBA, it is normally opened in the background. 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.

#WORD AND EXCEL FOR FREE CODE#

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. 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 In the Visual Basic Editor click Tools -> References select Microsoft Word x.xx Object Library. Let’s head back to the Excel VBA Editor and use the Early Binding method to control to Microsoft Word.

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.

#WORD AND EXCEL FOR FREE HOW TO#

In the first part we looked at the basics of how to reference other applications using Early Binding or Late Binding.

#WORD AND EXCEL FOR FREE SERIES#

This post is the second in a series about controlling other applications from Excel using VBA.

Word and excel for free