-Macro to Save-

[Guest]

Is there a way I can create a macro to:

Save a file, but automaically using the text in a certain cell as the filename?

 

[Dave Hawley]

Hi

Dim strFileName As String
strFileName = Sheet1.Range("A1")
ThisWorkbook.SaveAs strFileName & ".xls"

 

[Guest]

Thanx A lot