Environment: Win2K, Work2000
Attached Word document has an OpenXL and a CloseXL VBA subroutine.
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 24, 2018, 6:52 pm ad1c9bdddf
The solution assists with answering the question using VBA in Excel.
Using VBA in Exel Open and Close an .XLS File (and Process)
Attached Word document (Word2000) appears to successfully open and close an Excel file. BUT the Excel process is still there. [The Excel process goes away after I close the Word document]
I may not be 'fully closing' Excel...I would not think I would have to execute any 'special code' to close the process, and assume my VBA code is 'nearly right' but not quite right.View Full Posting Details