Set Destination Folder

[nniedzielski]

I am working with a macro that opens a file, pulls rows out and puts them into a workbook (wb). I am stuck on what to do when i want to save the workbook, how can i have the user set the destination for where to save the workbook when done? right now, I use this to tell them where to get the workbooks to get the data from: I assume the process is similar, i just dont know how to connect the dots

Set FldrPicker = Application.FileDialog(msoFileDialogFolderPicker)

    With FldrPicker
      .Title = "Select A Target Folder"
      .AllowMultiSelect = False
        If .Show <> -1 Then GoTo NextCode
        myPath = .SelectedItems(1) & "\"
    End With

 

[johnnyL]

Sub SaveFileAS()
    Application.GetSaveAsFilename
End Sub