Explore BrainMass

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.



Solution Preview

Please find the modified file of your code as a text format.

I have modified the OpenXL4OE_Click() function in your code with the following line. It was working fine on my machine.

XL.ScreenUpdating = True

Public ...