I am not sure if you wanted to close the SaveAs file and the original. If not the later, delete the thisworkbook.close line.
Sub SaveAnyFile()
Dim sName As String, sFolder As String
MsgBox "Next you will see the file name assigned to this payment, Following that you will be asked to select the lien folder of the Job Folder to which this invoice pertains."
On Error Resume Next
sName = Sheet1.Range("C11").Value & " - " & Sheet1.Range("C13").Value & " - " & Sheet1.Range("C18").Value & ".xlsm"
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Please select a folder"
.AllowMultiSelect = False
.Show
sFolder = .SelectedItems(1)
End With
sName = sFolder & "\" & sName
ActiveWorkbook.SaveAs sName, xlOpenXMLWorkbookMacroEnabled
ActiveWorkbook.Close False
ThisWorkbook.Close False
End Sub
Bookmarks