filename = range(B1).value & range(C1).value & range(E1).value

I'm assuming that the active sheet is the same sheet where these ranges are
stored.

You need to have your save code looking something like this:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Customer\Desktop\Book1.xls",
FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False


"Larry" wrote:

How would I go about saving a file as the concatenation of B1,C1, and E1 in a
macro