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.
Bookmarks