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
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?
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