Save As Macro

[boxer356]

Excel 2007
I have created a "save as" macro to grab the file name (AE2) and place it in the file name input area of the saved as menu of excel. The main goal was for the user to be able to select the directory in which the file will be saved.

Everything works EXCEPT it doesn't actually save the file when save is selected. It seems to be fine, the file is not saved.
Capture.JPG


Here is the macro that is set up.

Sub SaveAs()
'
' SaveAs Macro
'

'
myenteredname = Range("AE2").Value
myfilename = Application.GetSaveAsFilename(myenteredname, "Mircosoft Excel Workbook, *.xlsx")

End Sub

Hopefully someone can help me figure this one out.

TIA,
Tim