Save As "value in defined cell"

[Guest]

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.

 

[protonLeah]

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..