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

"sir_glen" skrev i en meddelelse
...

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 filename
A2_A3.xls

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

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

Thanks in advance.

Glen


--
sir_glen
------------------------------------------------------------------------
sir_glen's Profile:
http://www.excelforum.com/member.php...o&userid=14768
View this thread: http://www.excelforum.com/showthread...hreadid=273333