MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Filename Derived From A Cell


April 16, 2002 - by Bill Jelen

Arcangelo from Italy asks:

How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1?

This macro is amazingly straight-forward:

Public Sub SaveAsA1()
    ThisFile = Range("A1").Value
    ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub