why Excel not is closed?

[sal21]

To the end of my code i need to close Excel...

i use:

....
ActiveWorkbook.Close savechanges:=True

Application.Quit
....

Peraphs i need othe piece of code?

[HansV]

Where does this code reside? In the workbook that you're closing?

[HansV]

Try this instead:

ActiveWorkbook.Save
Application.Quit

[sal21]

Try this instead:

ActiveWorkbook.Save
Application.Quit

testd and it work perfect!
Tks

[sal21]

Try this instead:

ActiveWorkbook.Save
Application.Quit

hummmmm...

now, if i have 2 or more session of Excel opened the code Application.Quit, close all session!!!!
But I need to close only the active sessione vwhere the code is running ...

[HansV]

If you want to close only the active workbook, use

ActiveWorkbook.Close SaveChanges:=True

[sal21]

If you want to close only the active workbook, use

ActiveWorkbook.Close SaveChanges:=True

ok but the current Session of Excel remain active on screen, or not?

[HansV]

If you use Application.Quit, the active instance of Excel will close with all workbooks opened in that instance. Other instances of Excel will remain active.

If you use ActiveWorkbook.Close, only the active workbook will close, but the instance of Excel will remain active.

It's up to you to decide what you want.