Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Closing excel using macros

    Although i can close the active workbook using excel, i cant get excel to close itself completely.
    Any help please?

  2. #2
    Join Date
    Jan 2004
    Posts
    17
    if you want it to close and save the workbook to the current location you could use this:
    Sub Quit()
    Application.Quit
    ActiveWorkbook.Close SaveChanges:=True
    End Sub

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    thanx v much, it works!

Posting Permissions

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