Your One Stop for Excel Tips & Solutions


 

MrExcel - Photos of MrExcel

Excel Macro Uses Cell Value as File Name in Save As

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

Find more tips like this macro in 2500 Excel VBA Examples CD: