closing excel application

[sweet_dreams]

hi all,

Can you tell me how can I programatically close active excel application???

thx in advance for your help

regards,
sweet_dreams

[malik641]

Well if you know the workbook's name:
Sub CloseExcel()
Application.Workbooks("Book2").Close
End Sub
Or if you send the Procedure the name:
Sub CloseExcel(wb As Workbook)
Application.Workbooks(wb.Name).Close
End Sub

Hope this is what you were looking for :thumb:

[malik641]

Oh yeah, and to close all workbooks (without saving)
Sub CloseExcel()
With Application
.EnableEvents = False
.Workbooks.Close
.EnableEvents = True
End With
End Sub

[sweet_dreams]

thx malik641 but I was looking for something else. I was looking for something like that:

application.quite

code above closes whole excel application

but thx anyway

[malik641]

I thought there was an easier way.

Glad to see you got it moving.