Highlighted
New Member.
1591 views

Excel (error in Workbooks)

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

Tags (1)
0 Likes
4 Replies
Highlighted
Honored Contributor.
Honored Contributor.

RE: Excel (error in Workbooks)

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

0 Likes
Highlighted
New Member.

RE: Excel (error in Workbooks)

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

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

RE: Excel (error in Workbooks)

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

0 Likes
Highlighted
New Member.

RE: Excel (error in Workbooks)

I ll check that

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.