Excel_BookAttach can't find open, unsaved workbook

[lsallen142]

Hello everyone, 

I'm new to Autoit and have just recently wrote a basic script to open up SAP and download a report. This report is passed into Excel. So there will be an unsaved workbook opened.

The script will sometimes get out of sync if the data set is large and data has not yet been populated. I've been trying to use _excel_booklist to find the arrays of the open workbooks. This more or less works as expected. However, there is not path for the workbook obviously since it's not saved anywhere. I'm guessing the somewhere as a temp file but not as a .xlsx file.  My problem is I can't get _excel_bookattach to return the location of the workbook. Ultimately, I'm trying to use _excel_rangefind to check if the workbook is blank, that is, not fully downloaded. 

         Local $oExcel = ObjGet("", "Excel.Application")
         MsgBox($MB_SYSTEMMODAL, "Title", $oExcel) ;Returns title of workbook
         Local $aWorkBooks = _Excel_BookList($oExcel)
         _ArrayDisplay($aWorkBooks, "Excel UDF: _Excel_BookList Example 2 - List of workbooks of all instances") ;Returns the array list of open workbooks

 I can then find the title in the array. So I guess the "0" problem is because Col 2 is blank.

         Local $sString = $aWorkBooks[0][1]
         MsgBox($MB_SYSTEMMODAL, "Title", $sString)

This line doesn't seem to work without a path. Is there a way to use _excel_bookattach without a path and just a workbook title? Or is there some other method to check if a workbook is blank. 

$oWorkBook = _Excel_BookAttach($sString)

Right now I'm handling this all with sleep timers to wait a set amount of time for the files to fully download. 

 

[BrewManNH]

You need to use the $sMode parameter as stated in the help file. That parameter defaults to searching the file path of the string.