Closing excel through a VB code

[Mandar]

Please help me to write a macroi for closing a open excel file on clicking a button.

 

[anupamtiwari05]

Hi Mandar,


Could you please provide some more details what exactly do you want?


Thanks & Regards,

Anupam Tiwari

 

[Mandar]

Hi Anupam,


Actually I've created a button in an application as EXIT...I want the file to close after performing certain defined functions, like hiding few sheets, saving the file.

 

[Luke M]

This what you're looking for?

[pre]

Sub Examples()
'Close just this workbook
ThisWorkbook.Close

'Close all of Excel
Application.Quit

End Sub

[/pre]