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.
Bookmarks