a macro like:
Sub Macro1()
ActiveWorkbook.SaveAs _
Filename:=Range("E1").Value, _
FileFormat:=xlWorkbook, _
Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub


should get you started...


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=533067