In a workbook, on worksheet Sheet 1, in Cell A1 I have a value. Let's say
the value is the word "timesheet". How do I save the workbook with the
filename "timesheet"? Generically, how do I save a workbook to a filename,
where the filename is the value in a defined cell on a defined worksheet in
the workbook.
--
Bill

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