_Excel_BookOpen @error=3, @extended=-2147352567

[MB1]

I'm trying to open and existing Excel (xlsx) file and the script fails with the following error:

@error=3, @extended=-2147352567

The @error=3 means "Unable to open $sFilePath"

But I can't find where @extended=-2147352567 means.

Does anyone know what this extended error is?

Thanks in advance,

Mark

[water]

Welcome to AutoIt and the forum!

Could you please post the script you run and how you specify the workbook to open?

[MB1]

Here's the script:

#include <MsgBoxConstants.au3>
#include <Excel.au3>
#include <Date.au3>

ConsoleWrite(@LF & "Starting..." & @LF)

Local $oExcel = _Excel_Open()
If @error Then
   ConsoleWrite("Error executing Excel" & @LF)
   Exit 101
EndIf
ConsoleWrite("Created Excel Object." & @LF)

ConsoleWrite("Current directory: " & @WorkingDir & @LF)

Local $sWorkbook = @ScriptDir & "\testfile.xlsx"
ConsoleWrite("@ScriptDir: " & @ScriptDir & @LF)
ConsoleWrite("$sWorkbook: " & $sWorkbook & @LF)

Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, True)
If @error Then
  ConsoleWrite("Error opening '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended & @LF)
  ; _Excel_Close($oExcel)
  Exit 102
EndIf
ConsoleWrite("Loaded: " & $sWorkbook & @LF)

 

Here's the output:

C:\"Program Files (x86)"\AutoIt3\AutoIt3.exe c:\Forecasting\Excel_Files_For_Mark\OpenExcel3.au3

Starting...
Created Excel Object.
Current directory: C:\Program Files\BMC Software\Control-M Agent\Default
@ScriptDir: c:\Forecasting\Excel_Files_For_Mark
$sWorkbook: c:\Forecasting\Excel_Files_For_Mark\testfile.xlsx
Error opening 'c:\Forecasting\Excel_Files_For_Mark\testfile.xlsx'.
@error = 3, @extended = -2147352567

 

I'm calling the AutoIt3 and script from Control-M.

Thanks,

Mark

[MB1]

I was able to convince the server admin to run the script as the same user that Control-M is using. The script ran fine. I'm thinking this may be a permissions issue with Control-M and the xlsx file that I'm trying to open. Does -2147352567 indicate a permissions issue or is it just a general, something failed?

[water]

-2147352567 is the decimal value for the hex HRESULT 0x80020009. This stands for: Exception occurred.
So yes: It is a general exception.