saveas
 

Hello all,
Does anyone know how I can creat a macro which will save
the woorkbook so it would have a name as in one of the
cells (for example, B11 contains text "my files" and the
saved workbook after execution will have a name "my
files.xls").

Thank you in advance,
Nikita

saveas
 

Use SaveAs Method and set it equal to the cell with the text string.

On Tue, 16 Sep 2003 18:17:45 -0700, "Nikita"
wrote:

Hello all,
Does anyone know how I can creat a macro which will save
the woorkbook so it would have a name as in one of the
cells (for example, B11 contains text "my files" and the
saved workbook after execution will have a name "my
files.xls").

Thank you in advance,
Nikita