Saving a file with a name from a cell value.
Hi,
I need to write a macro that when executed, will save a file with the name
taken from the value of a specific cell in that spreadsheet.
you should have a cell named "myName" to make this line work:
ActiveWorkbook.SaveAs Filename:=Range("myName").Value
bye
arno
|