Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

close Excel programatically

Status
Not open for further replies.

amberH

Programmer
Jun 10, 2002
36
CA
Hello,
I have a workbook that is scheduled to run every morning. After it opens, it runs it's code, then closes down the workbook, but Excel remains open.
I can't figure out how to have it automatically close Excel down also.
Any suggestions?
Thanks,
amber
 
Hi Amber,

Try this...

Sub Workbook_Open()
Call_Subroutines_Here
ActiveWorkbook.Save
Application.DisplayAlerts = False
Application.Quit
End Sub

Hope this is what you were seeking. Please advise as to how it "fits". :)

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top