How do i save an excel spreadsheet from a captured cell?

[luke-sushi]

I would like to save an excel workbook using a specific captured cell from
that worksheet?

So when i go to save a workbook it will capture the information from cell D5
(for example) and use that info as its file name.

Is there a way of doing this?

In word when you go to save a document for the first time it will
automatically save it as the first few words written in the document.

Can this be done with excel?
And can it be specified to a particular cell in the worksheet?

 

[Sean Timmons]

you can save as a cell reference, though this would require programming code.

Set up so that it loks liek the below. Change C:\ to wherever you'd want it
to save and Range("A1") to the range you want to use as your save as filename.

ActiveWorkbook.SaveAs Filename:= _
"C:\" & Range("A1") & ".xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False