+ Reply to Thread
Results 1 to 5 of 5

save without prompt and close the workbook at the same time

  1. #1
    Registered User
    Join Date
    10-24-2008
    Location
    netherlands
    Posts
    35

    save without prompt and close the workbook at the same time

    I want the workbook to be saved and closed at the same time WITHOUT any prompts. Is this possible?
    I'm a newbie and can't find the right code.
    Your help is much appreciated (soory for my poor english).

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: save without prompt and close the workbook at the same time

    Please Login or Register  to view this content.
    Last edited by Bishonen; 10-26-2012 at 05:17 PM.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    10-24-2008
    Location
    netherlands
    Posts
    35

    Re: save without prompt and close the workbook at the same time

    Thanks, this does the trick.
    Additional question: same situation but then Excel must be closed. I tried Application.Quit but nothing happens:-(

  4. #4
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: save without prompt and close the workbook at the same time

    Please Login or Register  to view this content.
    is the proper way to go.

    Please attach the workbook where application.quit doesnt do the job and I'll be glad to look into it.

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    7,992

    Re: save without prompt and close the workbook at the same time

    Hi, Bishonen,

    Please Login or Register  to view this content.
    might be reduced to
    Please Login or Register  to view this content.
    or shorter
    Please Login or Register  to view this content.
    according to VBA-Help of Close(SaveChanges, Filename, RouteWorkbook).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1