PDA

View Full Version : Solved: Ask for values and save as



ermis1975
08-03-2008, 11:46 PM
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
08-04-2008, 12:56 AM
Look at inputbox in VBA help. Save the value and construct a filename from this.

ermis1975
08-04-2008, 01:59 AM
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
08-04-2008, 02:04 AM
That code is wrong, nothing should be after .xls. What opposite are you referring to?

ermis1975
08-04-2008, 03:06 AM
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
08-04-2008, 03:29 AM
ActiveWorkbook.SaveAs Filename:= "C:\TEMP\" & Format(Date, "yyyymmdd") & "name.xls"

ermis1975
08-04-2008, 04:30 AM
Thanks!!