HELP: Cell Value as Filename?
 

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

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