bajofuego, you could use a macro, something like this
Sub Save_As_Cell_valve()
ActiveWorkbook.SaveAs Filename:=Sheet1.Range("A1").Value & ".xls"
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"bajofuego" wrote
in message ...
Would it be possible to reference a cell value as a filename when saving
a worksheet?
For instance, say the sheet is an invoice and there's an invoice
number.
Aside from manually typing that number, is there a way to reference its
respective cell?
Any help with this is truly appreciated. Thank you.
--
bajofuego
------------------------------------------------------------------------
bajofuego's Profile:
http://www.excelforum.com/member.php...o&userid=24579
View this thread: http://www.excelforum.com/showthread...hreadid=381711