software

In a workbook, on worksheet Sheet 1, in Cell A1 I have a value. Let's say
the value is the word quot;timesheetquot;. How do I save the workbook with the
filename quot;timesheetquot;? 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(quot;E1quot;).Value, _
FileFormat:=xlWorkbook, _
Password:=quot;quot;, _
WriteResPassword:=quot;quot;, _
ReadOnlyRecommended:=False, _
CreateBackup:=False
End Subshould get you started...--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: www.excelforum.com/member.php...oamp;userid=32097
View this thread: www.excelforum.com/showthread...hreadid=533067