Hello!! I hope all is well.
Preface: I have a macro enabled excel file. Within that file, I have a button that the user can click and it will will pull up the Save As dialog box allowing the user to select the location to save the file.
Issue: When the file dialog box is shown, I need the File Name to read: "Client_Name " & Range("AO3").Value which is a cell containing a date (mm-dd-yyyy) and the filetype to be a Macro Enabled workbook or .xlsm file. Currently, I have the file type showing up correct but I cannot get the File Name to update properly.
Even when I remove the fName string and type in the name I want in Filename:= it will not update.
Help please!!! Thank you!!
Bookmarks