Skip to main content

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

the handles are not correct closed :)

olExcel is closed 2 times, olWrkSh is not closed... then the order is wrong :)

range is not used in the sample code,.. i think it is used somewhere... i would test

destroy olRange

destroy olWrkSh

destroy olSheets

destroy olWrkBk

destroy olExcel

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

i found that this is a knon bug and microfocus will fix that in extend 9.2.2 in february

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

we still use 8.1.3 :) and there is the most reason that the handles are not correct destroyed.

But this week we received the update to AcuCobol 9 :)

I think i will have a lot of fun in the new year!

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

We use 9.2.1 but microfocus will fix that in 9.2.2  as Claudio Contardi said to me via supportline

I am using excel in my program and after i finish it remains in memory in the task manager. How can i get rid of this?

77 olExcel HANDLE OF APPLICATION.
77 olWrkBk HANDLE OF WORKBOOK.
77 olWrkSh HANDLE OF WORKSHEET.
77 olRange HANDLE OF RANGE.
77 olSheets HANDLE OF SHEETS.
77 olFormat HANDLE OF VARIANT.

CREATE-AND-OPEN-EXCEL-FILE.
    CREATE @Application of @Excel handle in olExcel.
    MODIFY olExcel Workbooks::@_Open 

    (BY NAME FILENAME OPNSAV-FILENAME,
    BY NAME Format xlCSV,
    BY NAME Delimiter ";",)
    GIVING olWrkBk.

    INQUIRE olWrkBk sheets() in olSheets.
    INQUIRE olSheets item(1) in olWrkSh.
.
*
QUIT-AND-DESTROY-EXCEL.
   MODIFY olWrkBk @Close()
    MODIFY olExcel Quit()

    DESTROY olSheets
    DESTROY olRange
    DESTROY olExcel
    DESTROY olWrkBk
    DESTROY olExcel
.


#Excelstackintaskmanager

tested the last 2 days 9.2.1 and found no Problems with Excel.

Terms & ConditionsAccessibility statement