Jump to content
Sign in to follow this  
arunkw

Error while opening a Large Excel File

Recommended Posts

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

Share this post


Link to post
Share on other sites
Jos

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

Jos


Visit the SciTE4AutoIt3 Download page for the latest versions  - Beta files                                How to post scriptsource        Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.