How to Program a "Save As" Button in Excel VBA. ... When you select a folder and enter a file name to save the file with, the function will return the file path.