A macro that can save a file?

[sir_glen]

Is it possible to make a macro the will save the current spreadsheet?

I want to make a macro the will save the spreadsheet with the filenam
A2_A3.xls

So if A2 was "Bloggs" and A3 was "Joe" the file would save a
Bloggs_Joe.xls

I've allready made the macro clear certain cells but I've only don
this by using the record macro function and editing out certain part
cause I don't really understand visual basic

Thanks in advance.

Gle

 

[Jan Kronsell]

Something like

Dim FName As String

FName = ActiveSheet.Range("a2") & "_" & ActiveSheet.Range("a3")

ActiveWorkbook.SaveAs Filename:= _
FName, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False

should do it.

Jan