I've created an excel application to do some calculations. How would i close it, repressing the 'Do you want to save changes?' msgbox it displays.
I've tried XLApp.Quit
I've created an excel application to do some calculations. How would i close it, repressing the 'Do you want to save changes?' msgbox it displays.
I've tried XLApp.Quit
Code:' hide Excel messages from appearing on the screen
' by using the displayalerts call
With XLApp
.displayalerts = false
.workbooks(1).close
.displayalerts = true
.quit
End With
Set XLApp = nothing
Works great, thanks.:)