Solved: Ask for values and save as

[ermis1975]

I want to save a file contains values different each time for the name. So I have to set values A, B (after asking for them) and then put this in the filename save as.

[Bob Phillips]

Look at inputbox in VBA help. Save the value and construct a filename from this.

[ermis1975]

I find a way to save file name using a file name and after the date, but I cant to the oposite... ActiveWorkbook.SaveAs Filename:= _
"C:\TEMP\ Format(Date, "yyyymmdd") & ".xls" & "name"

[Bob Phillips]

That code is wrong, nothing should be after .xls. What opposite are you referring to?

[ermis1975]

Sorry... I meen:

ActiveWorkbook.SaveAs Filename:= "C:\TEMP\ Format(Date, "yyyymmdd") & "name" & ".xls"
(if I put first the name and after the date its ok.. But I need date first and name last.

[Bob Phillips]

ActiveWorkbook.SaveAs Filename:= "C:\TEMP\" & Format(Date, "yyyymmdd") & "name.xls"

[ermis1975]

Thanks!!