extension

Low level examples

Iterating the ROT

link https://www.mrexcel.com/board/threads/how-to-target-instances-of-excel.1118789/page-2#post-5395037

An example of iterating the Running Object Table (ROT) to find Excel Workbook instances.

Category: Low level examples

Host: mrexcel.com

Platforms: Windows

Office apps: All Office apps

Open on mrexcel.com

6 Q&A referencing Iterating the ROT

VBA objects this tool extends (6)

Running — Using Control Values While Code Is Running
Object — Refer to Cells by Using a Range Object
Object — Using events with the Application object
Table — Using events with the QueryTable object
Table — Exporting a Range to a Table in a Word Document
Excel — Using events with Excel objects

More from mrexcel.com (6)

Drag and Drop filepaths — Allow your userform to handle drag-and-drop files.
Custom Userform TitleBar color
Multi-color ListBox class
Safe Subclassing — Provides the ability to subclass Excel/Word/PowerPoint window or Userforms to perform further automation. In the later…
DLL Function Viewer — Allows the export of function names from DLLs.
Iterating Excel Instances via IAccessible — In some cases Excel instances aren't registered to the ROT. The Excel application however implements `IAccessible`,…