Logically, you'll likely want your Excel VBA SaveAs button to actually save the file using the file path that the user provided rather than just discarding that name.

Select "File" from the menu, choose "Save As..." and change the Save as Type to "Excel Macro-Enabled Workbook (*.xlsm)." Type a file name and choose "Save" to save the workbook with the macro.