Skip to main content

I create an excel file with many workbooks (worksheets) inside but after 281th workbook i create the program returns me an error. The line i am facing the error is the following:

           CREATE Application OF Excel HANDLE IN olExcel
           MODIFY olExcel @SheetsInNewWorkbook= W-B9-SHEETS-COUNTERS
           MODIFY olExcel Workbooks::Add() GIVING olWrkBk

variables:

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 OLRANGE HANDLE OF RANGE.

01 W-B9-SHEETS-COUNTERS  PIC 9(9).

Does anyone know why is that?


Giorgos


#Excel

I create an excel file with many workbooks (worksheets) inside but after 281th workbook i create the program returns me an error. The line i am facing the error is the following:

           CREATE Application OF Excel HANDLE IN olExcel
           MODIFY olExcel @SheetsInNewWorkbook= W-B9-SHEETS-COUNTERS
           MODIFY olExcel Workbooks::Add() GIVING olWrkBk

variables:

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 OLRANGE HANDLE OF RANGE.

01 W-B9-SHEETS-COUNTERS  PIC 9(9).

Does anyone know why is that?


Giorgos


#Excel

Memory Problem? In the Excel FAQ i find the only Limit: "Limited by available memory and system resources"

I create an excel file with many workbooks (worksheets) inside but after 281th workbook i create the program returns me an error. The line i am facing the error is the following:

           CREATE Application OF Excel HANDLE IN olExcel
           MODIFY olExcel @SheetsInNewWorkbook= W-B9-SHEETS-COUNTERS
           MODIFY olExcel Workbooks::Add() GIVING olWrkBk

variables:

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 OLRANGE HANDLE OF RANGE.

01 W-B9-SHEETS-COUNTERS  PIC 9(9).

Does anyone know why is that?


Giorgos


#Excel

Yes i saw that and my machine has 16gb of ram

I create an excel file with many workbooks (worksheets) inside but after 281th workbook i create the program returns me an error. The line i am facing the error is the following:

           CREATE Application OF Excel HANDLE IN olExcel
           MODIFY olExcel @SheetsInNewWorkbook= W-B9-SHEETS-COUNTERS
           MODIFY olExcel Workbooks::Add() GIVING olWrkBk

variables:

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 OLRANGE HANDLE OF RANGE.

01 W-B9-SHEETS-COUNTERS  PIC 9(9).

Does anyone know why is that?


Giorgos


#Excel

Not sure what version you are working with, your version may need ECN-4182 - Mav in Excel and ECN-4240 Mav when using Crystal Reports .. ECN-4240 cleaned up some internal handle issues

I create an excel file with many workbooks (worksheets) inside but after 281th workbook i create the program returns me an error. The line i am facing the error is the following:

           CREATE Application OF Excel HANDLE IN olExcel
           MODIFY olExcel @SheetsInNewWorkbook= W-B9-SHEETS-COUNTERS
           MODIFY olExcel Workbooks::Add() GIVING olWrkBk

variables:

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 OLRANGE HANDLE OF RANGE.

01 W-B9-SHEETS-COUNTERS  PIC 9(9).

Does anyone know why is that?


Giorgos


#Excel

I ll check that

Terms & ConditionsAccessibility statement