Macro to save file each day to specific folder with date in name

[sjhf]

Hello everyone,
This forum has been extremely helpful for me, but I’ve never posted anything before today. I’ve looked at a lot of other posts and could not get quite the answer I need.
Each day I receive a new report and have to format it and save it to a specific folder. I have the macro to do all the formatting but I can’t get it to save to “My Documents”.
This is what I have:

Range("Q1").Select
ActiveCell.FormulaR1C1 = "PDIP"
Range("R1").Select
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\pricer\My Documents & Range("Q1").Value & Format(Date, "mmddyyyy"), FileFormat _
:=xlCSV, CreateBackup:=False,

My macro types “PDIP” in Q1 so that is included in the name. I don’t think I need to do that but that’s what I have for now
I want it to save it to My Documents as a CSV with the name “PDIP(date)”. When I finish editing this line in the macro I get the error “Compile Error: Syntax Error”
Does anyone have any tips?

[hulpeloos]

in red

Please Login or Register  to view this content.

[sjhf]

Thanks you, hulpeloos. I knew it was something simple.