Can't get _excel_bookattach to work anymore

[handofthrawn]

My script below was working as of last week but now the book won't attach.  The first error code is 1 for the book attach, @extended = -2147352570.  When I do the rangeread, it confirms the first error code with a 1 return.

I do have two excel sheets running but I didn't think it would matter because the book was attached to the file I want.  I've read the help file, tried the example scripts, even had this script working but now its broken.

My autoit is up to date.  Any ideals?  Thanks.

 

 

#include <Misc.au3>
#include <Excel.au3>
#include <GUIConstants.au3>
#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>
#include <GUIListView.au3>
#include <MsgBoxConstants.au3>


AutoItSetOption("WinTitleMatchMode", 2)
WinActivate("Morning IND")
Global $sWorkbook = @DesktopDir & "\Morning IND.xls"
Global $oExcel = _Excel_BookAttach($sWorkbook) ; Path to excel file that is on the desktop
If @error Then  MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 2", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Global $var1 = _Excel_RangeRead($oExcel, Default, "X47") ; Symbol from X1
If @error Then  MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 2", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

 

[water]

If it worked and now it doesn't then something has changed:

• The script code
• The Excel workbook (name, directory where it is stored)
• New version of AutoIt installed
• New version of Excel installed
• ...
   

[handofthrawn]

On 4/7/2016 at 5:41 PM, water said:

I know this is an old thread but I wanted to thank water for the help.  I indeed messed up the directory and a couple other minor things.  Now I open everything in the correct order and it all works.  Thanks for making me double check the simple stuff.

 

[water]

Glad it is again working now and that the problem was not caused by the Excel UDF (bug or whatever).