howto: saveas with file name from a cell in the current worksheet
 

see subject

howto: saveas with file name from a cell in the current worksheet
 

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


"bob" wrote:

see subject

howto: saveas with file name from a cell in the current worksh
 

BigPig,
Thank you. I have that part, but what if I wanted to add in a specific
folder to save it to? Where would I add the folder string? That's where my
real issue is. Thank you again.
ActiveWorkbook.SaveAs Filename:=???????Range("A1").Value
Darren

"BigPig" wrote:

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


"bob" wrote:

see subject