[ jaskojsako @ 16.07.2016. 13:18 ] @
Pozdrav
koristim ovaj macro za izlaz iz excel fajla
ali ostane i dalje meni od excela
kako bi bio kod za izlaz iz kompletnog excela


Application.EnableEvents = False
ActiveWorkbook.Close SaveChanges:=True
Application.Quit

Hvala
[ FOX028 @ 17.07.2016. 17:36 ] @
Mislim da bi trebao probati sa Application.Close
[ jaskojsako @ 18.07.2016. 11:23 ] @
Probao ne može .
Isti slucaj ostane meni od excela
Hvala u svakom slucaju
[ Ivek33 @ 18.07.2016. 12:21 ] @
Vidi pomaže li ovo (naravno snimi wbk prije zatvaranja)
Citat:

This example closes Book1.xls and discards any changes that have been made to it.
Workbooks("BOOK1.XLS").Close SaveChanges:=True

This example closes all open workbooks. If there are changes in any open workbook, Microsoft Excel displays the appropriate prompts and dialog boxes for saving changes.
Workbooks.Close

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Quit
ActiveWorkbook.Close True
End Sub

ili
Code:

Sub SaveAndClose() 
    ThisWorkbook.Save 
    Application.Quit 
End Sub
[ jaskojsako @ 19.07.2016. 22:25 ] @
Hvala ali ne pomaže.