Explore BrainMass
Share

Explore BrainMass

    Using VBA in Excel, Open and Close an .XLS file and End Process

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Environment: Win2K, Work2000

    Attached Word document has an OpenXL and a CloseXL VBA subroutine.

    Procedure:
    Open the Task Manager.
    Click the OPENXL and notice (in the Task Manager) that the Excel process is created.
    Click the CloseXL and notice(in the Task Manager) that the Excel process DOES NOT GO AWAY.

    [Granted, if you close Word document, the process terminates, but I need to kill the process BEFORE closing Word (presumably using a slightly improved VBA subroutine).]

    © BrainMass Inc. brainmass.com October 9, 2019, 5:13 pm ad1c9bdddf
    https://brainmass.com/computer-science/security/using-vba-exel-open-close-xls-file-end-process-51377

    Attachments

    Solution Summary

    The solution assists with answering the question using VBA in Excel.

    $2.19