Hi,

I have pieced together the code below and it accomplishes what I need, but rather than save the new workbook to a folder on the C drive, I would like to save it to a folder on user's desktop. The folder is named "Driver Pay".

Can any help me tweak the code to redirect the file?

Sub DriverSummary()
    
    Dim strFileName As String
    
    strFileName = InputBox("Type a name for the new workbok", "File Name")
    If Trim(strFileName) = vbNullString Then Exit Sub
    
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    
    Range("A31:L41").Copy
    Sheets.Add.Range("A1").PasteSpecial xlPasteValues
    Application.CutCopyMode = False
    ActiveSheet.UsedRange.EntireColumn.AutoFit
    ActiveSheet.Move
    ActiveWorkbook.SaveAs "C:\Driver Pay\" & strFileName & ".xlsm", xlOpenXMLWorkbookMacroEnabled
    ActiveWorkbook.Close False
    
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    
End Sub
Thank you for any assistance.