bob,

You can do it with vba. Here's a small snippet that you can assign to a
command button. Where "A1" is the cell that you are using to name the file.

This will save in the last folder you saved to.

ActiveWorkbook.SaveAs Filename:=Range("A1").Value

HTH

Bigpig