Jump to content

Recommended Posts

Posted

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

Posted

You are running Excel 2002 on Windows 8?

My UDFs and Tutorials:

  Reveal hidden contents

 

Posted

According to MS only Office 2007, 2010 and 2013 are supported on Windows 8.

My UDFs and Tutorials:

  Reveal hidden contents

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...