Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Ektoras Giorgos
New Member.
1856 views

Excel remain in Tasks

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
.

0 Likes
5 Replies
neidingd Honored Contributor.
Honored Contributor.

RE: Excel remain in Tasks

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

0 Likes
Ektoras Giorgos
New Member.

RE: Excel remain in Tasks

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

0 Likes
neidingd Honored Contributor.
Honored Contributor.

RE: Excel remain in Tasks

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!

Ektoras Giorgos
New Member.

RE: Excel remain in Tasks

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

0 Likes
neidingd Honored Contributor.
Honored Contributor.

RE: Excel remain in Tasks

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

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.