Closing current file without saving - arrgh

[D_N_L]

Hi,

I have a workbook (.xlsm) which ultimately saves a version of itself as a CSV and closes that CSV file. I then want to close the .xlsm file without saving. I have the following code but whilst it closes it still leaves Excel open as an application. I have attached a JPEG of what I mean by this.

This is the code that I thought would work. What am I doing wrong?

Please Login or Register  to view this content.

[Izandol]

When you close the workbook the code will stop and therefore the application does not quit. You may try:

Please Login or Register  to view this content.

This does not actually save the workbook but merely tells Excel that it does not require saving.

[D_N_L]

Excellent!!!!

Been tearing my hair out on that one.