Error while opening a Large Excel File

[arunkw]

When Run

#include <Excel.au3>

$file = @ScriptDir & "\LargeExcelFile.xls"

$oExcel = _ExcelBookOpen($file, 0) ; open excel in the background

Gives Error

Line 409 (File "D:\Autioit\AutioIt3\Include\Excel.au3):

if $fsave Then $oExcel.ActiveWorkBook.Save

if $fsave Then $oExcel.ActiveWorkBook.Save^ERROR

Error: The requested action with this object failed

Where as if I use #include <ExcelCOM_UDF.au3> instead of #include <Excel.au3>

I get error

Line 398 (File "D:\Autioit\AutioIt3\Include\ExcelCOM_UDF.au3):

if $oExcel.ActiveWorkBook.Save

if $oExcel.ActiveWorkBook.Save^ERROR

Error: The requested action with this object failed

Note: if I use Excel File which is small or new it works fine

My LargeExcel File has around 250 Cplumns and 1000 Rows,

Kindly let me know if by changing any constant value is UDF will make a good diffrence and solve my problem

[Jos]

Start with using an ComErrorHandler as specified in the helpfile to see what the error description is.

Jos