Book on VBA Word AutomationUpload ImagesLink Dwight Arroyo 6 months ago
I am currently building an application in Visual Studio (Visual Basic) and I am using a Microsoft Access Database as my storage for all of the data. I am interacting a lot with Microsoft's Word application and need to automate many things some of which I can do in VS and others in AutoHotKey. I much rather use VBA to do all of the data manipulation instead of depending on VS or AHK. What would be the best book to get on Automating Word using complete VBA code? Again, any suggestions will be greatly appreciated. Thank you.
Kevin Yip 6 months ago
A book on Word VBA should be enough, because you are mainly concerned with Word VBA in carrying out your tasks. "Automation" is just a way to grab data from another Office app. Even if the book doesn't cover automation, it should be easy to learn it yourself, because the VBA for automation is simple. I have two examples below that create a table in Word with Access data in it. Whether you use Word automation from Access, or Access automation from Word, the code is largely the same as the pictures show. They differ mainly in how Word "talks" to Access and how Access talks to Word.
Kevin Yip 6 months ago
Dwight Arroyo 6 months ago
Thank you for your reply Kevin.
I will try to search for a book on Word VBA.
I am specifically in the middle of automating the mail merge in Word where
the user only needs to select specific records from the database and then generate
all mail merge documents with just one click.
Thanks again for your input.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
