![]() ![]() ![]() 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. 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 Comments
Leave a Reply. |