Excel application not closing

[D_N_L]

Hi all,

I'm pulling my hair out with this. I have the below code which essentially saves a range on a workbook as a text file and then I want the code to shut Excel down completely (after saving the original file but not saving the WHHols file (which is what the name of the original file becomes after saving the range as a text file). The below code works fine I just can't get it to close everything without leaving a residue in Task Manager. I've tried all sorts of permutations without success.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Why not just put the Application.Quit immediately after the text file is saved?
You're not subsequently saving the current workbook and there's no need for a Close event with the txt file since the application quit effectively closes everything anyway.

[D_N_L]

I would hug you if I could!! That was driving me to distraction. God bless you.

[Richard Buttrey]

My pleasure.

Glad I could help and thanks for the rep.