when i hit save as, i would like excel to refer to a certain cell on my
spreadsheet to name the spreadsheet file. is there a way to do this?


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=382106

lsu-i-like Wrote:
when i hit save as, i would like excel to refer to a certain cell on my
spreadsheet to name the spreadsheet file. is there a way to do this?
Isu,
With a macro,
Something like;
Asumimg cell you want to use is B2.
Subsitute your path to where you want the file to be saved.

Sub SaveAsFileName()
ActiveWorkbook.SaveAs Filename:="C:\Documents and
Settings\Owner\Desktop\" & Range("B2").Value & ".xls"
End Sub

Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=382106