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. ![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |