does anyone know how to close the excel application from vba?
Printable View
does anyone know how to close the excel application from vba?
try using "application.quit" it should work.
vbaex
jay-z
You did not mention how you open it but i guess you are
using:
Private Exc as Excel.Application
...
...
...
Set Exc = New Excel.Application
Exc.Visible = True
So to terminate it just use
Exc.Quit
(If you don't want any 'Do You Want to Save Your Changes
Questions you can use 'Exc.DisplayAlerts =False ')
Hope it helps..