How can I get the file name from the "Save As" input box (NOT the file dialog) prior to saving?

Question

I am trying to do some validation on the file name before it's saved. Here are my three file-saving scenarios: File > Save File > Save As > Browse > Save File > Save As > Save Additional Info: As defined in the Workbook_BeforeSave event, the SaveAsUI parameter will indicate whether or not a dialog box is needed to save changes. ✓ In scenario 1, SaveAsUI=False, so I get the filename from ThisWorkbook.Name ✓ In scenario 2, SaveAsUI=True, so I force a dialog and get the file name with the GetSaveAsFilename method ✗ In scenario 3, SaveAsUI=True, but no intermediary dialog is ever actually required! The file gets immediately saved to that name entered in the input box. ...it's ridiculous that I'm obsessing over this because I can just override scenario 3 and force a dialog anyways, but I'm curious. Any ideas? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

I'm writing this as an answer, because the comment field is too small for it. I found the mentioned file reference in the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\User MRU\AD_2B763A186A5179F1E2C2819B76BF6FDEF3F399938D48925BE3381441F2190369\File MRU You'll need a find, either to open the Recent file list, or to find a way to read such a registry entry. One way (but quite a complicated one), the Shell command, as you can see here (commandline command): reg query "HKCU\Software\Microsoft\Office\16.0\Excel\User MRU" /s Launching this command and parsing the results might help you.