Close current application

[Undo]

Hello

how can i close current excel application?
i cant use Application.Quit, because it will close all opened excel files
and ActiveWorkbook.Close will close only workbook, without close excel application
i want close only that excel i put the code it

thanks

[Richard Buttrey]

I don't understand your request.
You seem to be asking how you can close Excel but still have open workbooks which don't contain code.

Please clarify. Stating the obvious but to be able to see a workbook you need to have Excel open.

[KOKOSEK]

Agree with Richard. A bit confused.
However, maybe close all *.xlsm files and leave *.xls open?

[Richard Buttrey]

Agree with Richard. A bit confused.
However, maybe close all *.xlsm files and leave *.xls open?

@e97h

If that's the case then one way

Please Login or Register  to view this content.

[Undo]

Thanks all and sorry, i will explain better

i want vba code to close active workbook, but before the close i want code to stop all macros.. without stop macros application will not close.. it will open again


test sub
' stop macros
' close active workbook
end sub

[Richard Buttrey]

Perhaps you'd better upload the workbook. I'm reading this as something different.

You now appear to be saying that you want to stop a macro that's presumably running and preventing you stopping the macro, closing a workbook and by extension closing the application.