Skip to main content

[Migrated content. Thread originally posted on 10 March 2003]

CREATE @Application OF @Excel HANDLE IN EXCEL-APP.
MODIFY EXCEL-APP @SheetsInNewWorkBook = 1.
MODIFY EXCEL-APP @GetOpenFilename()
GIVING FIELD.

MODIFY EXCEL-APP @Workbooks::Open(FIELD)
GIVING EXCEL-WORKBOOK.

********* MODIFY EXCEL-APP @VISIBLE = 1.
inquire EXCEL-WORKBOOK
@Worksheets::item(1) in EXCEL-WORKSHEET.

DESTROY EXCEL-WORKSHEET.
DESTROY EXCEL-WORKBOOK.
DESTROY EXCEL-APP.

THE EXCEL IS STILL IN MEMORY AND WITH THE OPEN WORKSHEET

[Migrated content. Thread originally posted on 10 March 2003]

CREATE @Application OF @Excel HANDLE IN EXCEL-APP.
MODIFY EXCEL-APP @SheetsInNewWorkBook = 1.
MODIFY EXCEL-APP @GetOpenFilename()
GIVING FIELD.

MODIFY EXCEL-APP @Workbooks::Open(FIELD)
GIVING EXCEL-WORKBOOK.

********* MODIFY EXCEL-APP @VISIBLE = 1.
inquire EXCEL-WORKBOOK
@Worksheets::item(1) in EXCEL-WORKSHEET.

DESTROY EXCEL-WORKSHEET.
DESTROY EXCEL-WORKBOOK.
DESTROY EXCEL-APP.

THE EXCEL IS STILL IN MEMORY AND WITH THE OPEN WORKSHEET
Is this supposed to be a question?

[Migrated content. Thread originally posted on 10 March 2003]

CREATE @Application OF @Excel HANDLE IN EXCEL-APP.
MODIFY EXCEL-APP @SheetsInNewWorkBook = 1.
MODIFY EXCEL-APP @GetOpenFilename()
GIVING FIELD.

MODIFY EXCEL-APP @Workbooks::Open(FIELD)
GIVING EXCEL-WORKBOOK.

********* MODIFY EXCEL-APP @VISIBLE = 1.
inquire EXCEL-WORKBOOK
@Worksheets::item(1) in EXCEL-WORKSHEET.

DESTROY EXCEL-WORKSHEET.
DESTROY EXCEL-WORKBOOK.
DESTROY EXCEL-APP.

THE EXCEL IS STILL IN MEMORY AND WITH THE OPEN WORKSHEET
I want to now why excel his still in memory because i did destroy and after the destroy he is keeping a lock on the file and have it in memory?

[Migrated content. Thread originally posted on 10 March 2003]

CREATE @Application OF @Excel HANDLE IN EXCEL-APP.
MODIFY EXCEL-APP @SheetsInNewWorkBook = 1.
MODIFY EXCEL-APP @GetOpenFilename()
GIVING FIELD.

MODIFY EXCEL-APP @Workbooks::Open(FIELD)
GIVING EXCEL-WORKBOOK.

********* MODIFY EXCEL-APP @VISIBLE = 1.
inquire EXCEL-WORKBOOK
@Worksheets::item(1) in EXCEL-WORKSHEET.

DESTROY EXCEL-WORKSHEET.
DESTROY EXCEL-WORKBOOK.
DESTROY EXCEL-APP.

THE EXCEL IS STILL IN MEMORY AND WITH THE OPEN WORKSHEET
I don't see what you have defined FIELD as, but I presume it is not that part that causes your experience. But rather the fact that you do not A) Close the workbook and B) Shut down Excel, which you have to.

I suggest you modify this part:

DESTROY EXCEL-WORKSHEET.
DESTROY EXCEL-WORKBOOK.
DESTROY EXCEL-APP.

To:

DESTROY EXCEL-WORKSHEET.
MODIFY EXCEL-WORKBOOK @Close(0).
DESTROY EXCEL-WORKBOOK.
MODIFY EXCEL-APP @Quit().
DESTROY EXCEL-APP.

And I would expect it to clean up nicely.
Terms & ConditionsAccessibility statement