The value of C1 is not always John Smith. it's always this format "First Name
last name, date of birth"

so it could be:

John Smith, 12/18/1954
Adam Bloomberg, 1/15/1984
etc

Thanks Dave

Dave Peterson wrote:
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path _
& "\" & Range("C1").Value

becomes

ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\John Smith.xls"

Hi,
This code works for me but one issue. I want to save the file under the
[quoted text clipped - 22 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1