Wise Owl Answers - How do I refer to an open Word document in Excel VBA? 

By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to get a reference to an open Word document using Excel VBA. You'll learn how to use the GetObject function to reference a running instance of Word and how to add error handling code to deal with occasions when Word isn't running. You'll also see how to quit the application, close all documents leaving the application open, close a single document and how to loop through the documents collection.
Chapters
00:00 The Question
00:51 Referencing an Existing Instance of Word
01:54 Adding Error Handling Code
03:57 Close All Documents but Keep Word Open
04:45 Close a Specific Document
05:27 Saving Changes when Closing a Document
06:30 Looping Through the Documents Collection
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!