Changing a File Name and where it is saved

[mlarson]

I have a macro that includes the location to save a file and what the file's name should be. I would like to change both.

Do you know what I need to change in the macro below so the file is saved at the following location? C:\Users\Mark\Desktop\SupportBooks

 'Folder where you want to save the Excel file
    DefPath = Application.DefaultFilePath
    If Right(DefPath, 1) <> "\" Then
        DefPath = DefPath & "\"
    End If

And what do I need to change in the macro below to have the file name be MarkFile1 without any date or time stamp (the code below provides a date and time stamp but I don't need it)?

'Name of the Excel file with a date/time stamp
    XLSFileName = DefPath & "MasterCSV " & _
    Format(Now, "dd-mmm-yyyy h-mm-ss") & FileExtStr

Thanks for your help!

 

[cb12]

Try:

DefPath = "C:\Users\Mark\Desktop\SupportBooks\"

and

XLSFileName = DefPath & "MasterCSV" & FileExtStr

 

[mlarson]

Excellent, thank you!