close excel after finishing task

R

rachel

Hi
I wrote an application in VBA that opens by shortcut, do a lot of
things, such as creating charts, files etc.
I close all the files but excel is still open. How can I close Excel .
thanks
 
C

Cole

try this


Sub test()
'------
'Procedures
'------

Application.DisplayAlerts = False
Application.Quit
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink fails to open on the first click 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word 2003 won't exit 8
Can't close old pst file 2
Excel opening 1
Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
Autonumber field in Excel that behaves the same as Access 0

Top