Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    31

    Angry Unanswered: how exit without answering YES or NO

    I have a workbook (with two macro) that read input file and then run its macro on the first macro produce workbook and left it open, the second macro it run an create 3 more report in a c:\path\data directory

    I would like to know how I can close my workbooks without answering YES or NO
    It is always asking to close my open data file??
    I have tried using Activeworkbook.close or even
    Sub Save_Exit()
    Application.Quit
    ThisWorkbook.Close SaveChanges:= False
    End Sub
    But

    What do I need to close all my worksheet and workbook automatically without answering yes or no

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    This soulution to quit Excel with no questions asked seems to work:

    Application.DisplayAlerts = False
    Application.Quit

    Jerry

  3. #3
    Join Date
    Sep 2003
    Posts
    31
    Thank you Jerry
    That did it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •