+ Reply to Thread
Results 1 to 6 of 6

How to ignore save as popup in file dialog?

  1. #1
    Registered User
    Join Date
    03-19-2021
    Location
    North America
    MS-Off Ver
    2010
    Posts
    2

    How to ignore save as popup in file dialog?

    Hi, I'm using the below sub get a file path for a user form.
    I'm trying to find a way to stop the "Confirm Save As" message from appearing. I'm already saving later on in my program and don't need the confirmation appearing here. Automatically accepting the save as message would also work.
    (As best I can tell everything else about this sub is working properly.)

    I already tried setting EnableEvents and DisplayAlerts to false, neither of which worked. I assume this is because the confirmation message is coming from the file dialog instead of directly from Excel.

    Thanks in advance.

    Please Login or Register  to view this content.
    Last edited by JSU12345; 03-22-2021 at 10:28 AM.

  2. #2
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: How to ignore save as popup in file dialog?

    enumerations is part of excel. built in. can not stop it. unless you good hacker. it not worth the time

    https://docs.microsoft.com/en-us/off...filedialogtype

    never heard of anyone being able to automatic click dialog built in. there workarounds though. but that take lots of code.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to ignore save as popup in file dialog?

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to ignore save as popup in file dialog?

    Use msoFileDialogFolderPicker instead of msoFileDialogSaveAs.






    Quote Originally Posted by omahaNative_1023 View Post
    enumerations is part of excel. built in. can not stop it. unless you good hacker. it not worth the time

    https://docs.microsoft.com/en-us/off...filedialogtype

    never heard of anyone being able to automatic click dialog built in. there workarounds though. but that take lots of code.
    You have misunderstood the question and in any case your post does not contribute to a solution.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: How to ignore save as popup in file dialog?

    I'd suggest Application.GetSaveAsFileName if you don't actually want to save at this point.
    Rory

  6. #6
    Registered User
    Join Date
    03-19-2021
    Location
    North America
    MS-Off Ver
    2010
    Posts
    2

    Re: How to ignore save as popup in file dialog?

    Application.GetSaveAsFileName worked perfectly. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. save file no dialog
    By tim_p in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2020, 08:48 AM
  2. Populate file path and file name in save as dialog box using text in worksheet
    By runnerD2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2016, 05:04 PM
  3. [SOLVED] File Save As Dialog with VBA
    By Pho6 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2014, 01:21 PM
  4. [SOLVED] Popup to save file as PDF
    By learningslowly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 04:11 PM
  5. How to Save A File Using Dialog Box?
    By mitchivous in forum Excel General
    Replies: 0
    Last Post: 07-14-2013, 10:24 PM
  6. [SOLVED] automatic name in 'save as dialog box' ok, but does not actually save the file?!
    By Pluym in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2012, 10:05 AM
  7. save file dialog box
    By Directlinq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2009, 04:43 PM

Tags for this Thread

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