+ Reply to Thread
Results 1 to 5 of 5

save without prompt and close the workbook at the same time

  1. 10-26-2012, 05:10 PM #1
    bta
    bta is offline
    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).
    Reply With QuoteRegister To Reply
  2. 10-26-2012, 05:14 PM #2
    Bishonen
    Bishonen is offline
    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.
    Reply With QuoteRegister To Reply
  3. 10-27-2012, 06:09 AM #3
    bta
    bta is offline
    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:-(
    Reply With QuoteRegister To Reply
  4. 10-27-2012, 06:29 AM #4
    Bishonen
    Bishonen is offline
    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.
    Reply With QuoteRegister To Reply
  5. 10-27-2012, 06:43 AM #5
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1