Skip to main content

[archive] For the sample

  • March 11, 2003
  • 3 replies
  • 1 view
Dominique Sacre
Forum|alt.badge.img+2

[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

    3 replies

    Dominique Sacre
    Forum|alt.badge.img+2

    [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?
    Dominique Sacre
    Forum|alt.badge.img+2

    [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?
    Dominique Sacre
    Forum|alt.badge.img+2

    [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.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement