I can not open an existing excel file using AutoIT

[marynguyenkk]

I have written a short program to open an existing Excell.

The code is as below:

When I execute my code, no error, but the file did not open.  (The name of the file is Music Theory.xlsx)

Any help is highly appreciate.

Thank you

Mary

#include <Excel.au3>
#include <array.au3>

Local $sFilePath1 = "C:UsersmnguyenDesktopMy Doc & Music Theory.xlsx" ;This file should already exist

Local $oExcel = _ExcelBookOpen($sFilePath1)

$oExcel = _ExcelBookOpen("$sFilePath1, 0")    ; Open Excell in the background
_ExcelSheetActivate($oExcel,"Music Theory.xlsx")    ; Name of the sheet

$aArray = _ExcelReadSheetToArray($oExcel, 2) ; ignoring the header row (So it starts from 2, By default, starts from 1)

_ArrayDisplay($aArray, "Array using Default Parameters")

For $i = 1 to UBound($aArray)
 $name   = $aArray[$i][1]   ; Storing the array values in a variable $name
 MsgBox(0,'debug', $name)    ; Displaying the values using message box
Next
_ExcelBookClose($oExcel)            ; close excel

[water]

Welcome to AutoIt and the forum!

You have posted in the wrong forum. The best place is the General Help and Support forum.

I'll ask a Mod to move the thread.

[water]

The Excel UDF that comes with AutoIt doesn't support the file formats implemented with Excel 2007.

Please have a look at my rewrite of the Excel UDF (download link can be found in my signature). This new UDF supports all file formats and much more

[l3ill]

Could this be the problem?

Local $sFilePath1 = "C:UsersmnguyenDesktopMy DocMusic Theory.xlsx" ;This file should already exist

_______________________________________^^^^^^^^^^^^^^^^

[water]

BTW: Please enclose your script in code tags (that's the blue "A" in the editor). That greatly enhances readability!

[BrewManNH]

BTW, why are you using 2 _ExcelBookOpen lines?

Local $oExcel = _ExcelBookOpen($sFilePath1)
 
$oExcel = _ExcelBookOpen("$sFilePath1, 0")    ; Open Excell in the background

The second one is also written wrong, you need to lose the quotes around the parameters.