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




Reply With Quote