I have some AutoIt scripts that run fine under Windows XP but do not run under Windows 8. The problem appears to be the _ExcelBookOpen statement fails. I've used the following example script from the Help file for a test.
; ***************************************************************
; Example 1 - Open an existing workbook and returns its object identifier.
; *****************************************************************
#include
Local $sFilePath1 = @ScriptDir & "\Test.xls" ;This file should already exist
Local $oExcel = _ExcelBookOpen($sFilePath1)
If @error = 1 Then
MsgBox(0, "Error!", "Unable to Create the Excel Object")
Exit
ElseIf @error = 2 Then
MsgBox(0, "Error!", "File does not exist - Shame on you!")
Exit
EndIf
Running this produces the Error message box Unable to Create the Excel Object.
I'm using Microsoft Excel 2002.
I need some help to correct or work around this problem.
Thank you - Dick