Excel_BookOpen doesn't work at all, even using the example.

[water]

Use _Excel_Open, _Excel_BookNew, _Excel-BooksSaveAs to create a new workbook and save it to your disk. Then use _Excel_BookOpen to open it again and see what happens.

[Jos]

Show me the SciTE console output when you run it so I can tell you it is working properly

Jos

[Hyflex]

Use _Excel_Open, _Excel_BookNew, _Excel-BooksSaveAs to create a new workbook and save it to your disk. Then use _Excel_BookOpen to open it again and see what happens.

Err, it doesn't even open excel: http://i.imgur.com/ew7SFB2.png (excel is not open at all,

Show me the SciTE console output when you run it so I can tell you it is working properly

Jos

Here we go: http://i.imgur.com/rtfSweZ.png

[water]

This means that there was a running intance of Excel where _Excel_Open attached to. Does the task manager show a running Excel process before you start the script?

[Hyflex]

This means that there was a running intance of Excel where _Excel_Open attached to. Does the task manager show a running Excel process before you start the script?

Nope, there is no excel running and even after rebooting and trying still the same thing.

[water]

Has there ever been a trial version of MS Office installed on this machine?

[Jos]

Err, it doesn't even open excel: http://i.imgur.com/ew7SFB2.png (excel is not open at all,

Here we go: http://i.imgur.com/rtfSweZ.png

ok, so you don't have the full scite4autoit3 installed and are running the x86 version of autoit3!

jos

 

[Hyflex]

Has there ever been a trial version of MS Office installed on this machine?

Nope, never.

ok, so you don't have the full scite4autoit3 installed and are running the x86 version of autoit3!

jos

 

During Run: http://i.imgur.com/WQqMEt8.png After Run: http://i.imgur.com/zjXQPhF.png

[Jos]

Ok you are now running autoit3wrapper, but thought you added the #autoit3wrapper statement to run the x64 version of autoit3?

Jos

[Hyflex]

Ok you are now running autoit3wrapper, but thought you added the #autoit3wrapper statement to run the x64 version of autoit3?

Jos

http://i.imgur.com/ISmXRwk.png and http://i.imgur.com/yIDFcX2.png

What else do I try? (I could give temporary remote control access if you wish to test some stuff)

[Jos]

Strange, you are still running the x86 version. Do you have an autoit3_x64.exe in the autoit program directory?

jos

[Bert]

I'm not sure how you mean.

Ok, allow me to rephrase it. Run this script and post your results:
 

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

; Create application object and open an example workbook
Local $sWorkbook = @ScriptDir & "\Extras\_Excel1.xls"
Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook)
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example", "Error opening workbook '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oAppl)
    Exit
EndIf

 

[Hyflex]

Strange, you are still running the x86 version. Do you have an autoit3_x64.exe in the autoit program directory?

jos

Yep, it's there, same date and time as AutoIt3.exe

Reinstalling Autoit and switching default to x64 still gives me the same error but atleast it runs with x64.

Ok, allow me to rephrase it. Run this script and post your results:
 

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

; Create application object and open an example workbook
Local $sWorkbook = @ScriptDir & "\Extras\_Excel1.xls"
Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook)
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookAttach Example", "Error opening workbook '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oAppl)
    Exit
EndIf

 

Error 2: http://i.imgur.com/Uzd3KLy.png (Same error with and without the double slash for C:\\Extras, same error also if I try in other folder locations)

[Bert]

you didn't modify the code did you before you ran it? You need to run it EXACTLY as written when I posted it. I see you point the path to the root of C in the screenshot. That will cause a failure. 

[Hyflex]

you didn't modify the code did you before you ran it? You need to run it EXACTLY as written when I posted it. I see you point the path to the root of C in the screenshot. That will cause a failure. 

I ran it exactly how you posted AND also ran it slightly modified by removing 1 slash because I tried it in C:/ as well.

[BrewManNH]

If you're running the code as posted by Bert, it won't work for you unless you have an excel file called _Excel1.xls in a folder called Extras under whatever folder you're running the script from. That script came from the help file example and that example script assumes that the scriptdir is in the AutoIt3 folder, which is located at AutoIt3\Examples\Helpfile, because that is where the help file example scripts are stored by default.

 

[Hyflex]

If you're running the code as posted by Bert, it won't work for you unless you have an excel file called _Excel1.xls in a folder called Extras under whatever folder you're running the script from. That script came from the help file example and that example script assumes that the scriptdir is in the AutoIt3 folder, which is located at AutoIt3\Examples\Helpfile, because that is where the help file example scripts are stored by default.

 

I had already made a folder in C:/Extras and created the excel file in there, however I also just tried it in the autoit example helpfile folder but it still didn't work.

[BrewManNH]

When you run this script from SciTE, if you look in the output panel in Scite, what is the name of the AutoIt3 exe file being run? If it's not AutoIt3_x64.exe then you're running the x86 version of AutoIt and that probably won't work to run the x64 version of Excel.

[Hyflex]

When you run this script from SciTE, if you look in the output panel in Scite, what is the name of the AutoIt3 exe file being run? If it's not AutoIt3_x64.exe then you're running the x86 version of AutoIt and that probably won't work to run the x64 version of Excel.

It's the x64 version, i changed it before by reinstalling autoit and choosing x64

[Hyflex]

Still can't get this working at all..