Explore BrainMass

Using VBA in Exel Open and Close an .XLS File (and Process)

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

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.

© BrainMass Inc. brainmass.com September 22, 2018, 5:53 am ad1c9bdddf - https://brainmass.com/computer-science/files/using-vba-exel-open-close-xls-file-process-51319


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

Solution Summary

The solution assists with opening and closing an Excel file using VBA.