TechHelp

Book on VBA Word Automation Upload Images Link
Dwight Arroyo
26 days 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
25 days 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
25 days ago

Dwight Arroyo
21 days 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.

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated