saveas

[Nikita]

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

 

[d.winkler]

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