HELP: Cell Value as Filename?

  • Thread starter Thread starter bajofuego
  • Start date Start date
B

bajofuego

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, 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
 
Back
Top