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

[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.