Save file with user input for filename

[kjm1969]

Hello world!! I am attempting to work in water over my head!! Yea me!!
I need help putting together the code to allow a user to click a button, have an input window pop up and ask for the files name and then save the file in a predetermined location as that file name. I am not all that good at the VBA code. Very much a beginner but I'm leanring everyday. Can anyone offer sugestions for this??

 

[VoG]

Try like this

Sub SaveMe()
Dim fName As String
fName = InputBox("Enter filename")
If fName = "" Then Exit Sub
With ActiveWorkbook
    .SaveAs Filename = .Path & "\" & fName & ".xls"
End With
End Sub