filmov
tv
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:
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
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:
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
0:20:41
Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?
0:06:22
Wise Owl Answers - How Do I Open Google Chrome in Full Screen Mode using Selenium in VBA?
0:07:42
Wise Owl Answers - How do I hide all but the selected sheets in Excel?
0:09:18
Wise Owl Answers - How do I refer to an open Word document in Excel VBA?
0:10:38
Wise Owl Answers How do I group a pivot table by a numeric field using VBA?
0:12:05
Wise Owl Answers - How do I add a filename to the results of an ADODB query?
0:18:06
Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?
0:18:59
Wise Owl Answers - How do I draw a line in a cell in Excel VBA?
0:37:26
Wise Owl Answers - How do I loop through sheets in multiple closed Excel files?
0:05:05
Wise Owl Answers - How do I open Google Chrome with a user profile using VBA?
0:12:42
Wise Owl Answers - How do I refer to the previous column in a matrix in SSRS?
0:18:40
Wise Owl Answers - How do I add a Select All option to a VBA list box?
0:12:19
Wise Owl Answers - How do I list all properties of a file using VBA?
0:19:13
Wise Owl Answers - How do I copy data from multiple worksheets in other workbooks?
0:21:42
Wise Owl Answers - How do I get data from a closed Excel file using VBA?
0:15:06
Wise Owl Answers - How do I use Google Translate with Excel VBA?
0:05:17
Wise Owl Answers - How do I refer to a field name with a dot in ADODB?
0:05:58
Wise Owl Answers - How do I count the rows in an ADODB recordset?
0:09:16
Wise Owl Answers - Is it Possible to Start Chrome Hidden using Selenium in VBA?
0:26:23
Wise Owl Answers - How do I find a folder with a partial name in VBA?
0:23:24
Wise Owl Answers - How do I scroll down a web page in Chrome with Selenium for VBA?
0:20:36
Wise Owl Answers - How do I get data from multiple closed Excel files using VBA?
0:09:40
Wise Owl Answers - How do I populate an array with an ADODB recordset?
0:18:10
Wise Owl Answers - How do I copy sheets from multiple Excel files into one worksheet?
Комментарии