This Excel VBA Save As Tutorial explains real example of VBA Code to save a file to specific location or save a file in a specific folder.
You can also learn how to use save as dialog box to save a workbook using vba code.