Loop through all open Excel.Application Objects

[if1467]

I have a situation where I have multiple instances of excel open and i am trying to use _ExcelBookAttach to get 1 workbook from all the open instances.  The ObjGet picks up the 1st instance of excel that was opened but that is not always the one that has the workbook I need. Is there a way to loop through all the open Excel.Application objects so that I can check each on to see if the correct workbook is in that instance? I stripped down the _ExcelBookAttach UDF to demonstrate what I am looking for.
 

#include <Excel.au3>
Opt("WinTitleMatchMode", 2)
 
$objExcelBookTemp=_ExcelBookAttach1("Sheet1","Title")
_ExcelWriteCell($objExcelBookTemp,"TestCell",1,1)
 
 
Func _ExcelBookAttach1($s_string, $s_mode = "FilePath")
Local $o_Result
$o_Result = ObjGet("", "Excel.Application")
 
;Object Loop Starts Here
Local $o_workbooks = $o_Result.Application.Workbooks
For $o_workbook In $o_workbooks
If StringInStr($o_workbook.Application.Caption, $s_string) Then
Return $o_workbook
EndIf
Next
;Object Loop Ends Here
 
ConsoleWrite("--> Warning from function _ExcelAttach, No Match" & @CRLF)
Return SetError(1, 5, 0)
EndFunc   ;==>_ExcelBookAttach

[water]

Please have a look at my rewrite of the Excel UDF (for doenload please check my signature). This allows to handle multiple instances.

[if1467]

Thanks water.  That got me going in the right direction.  I also found that I needed to update to v3.3.10

[water]

If there is something missing in the UDF, please let me know. It's still in beta status but will replace the current Excel UDF in the next beta release of AutoIt.