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:


Warning: require_once(/usr/www/users/mrexcel/siteadmin/admincp/includes/classes/RightBox.php): failed to open stream: No such file or directory in /usr/www/users/mrexcel/includes/right-col.php on line 2

Fatal error: require_once(): Failed opening required '/usr/www/users/mrexcel/siteadmin/admincp/includes/classes/RightBox.php' (include_path='.:/usr/local/lib/php') in /usr/www/users/mrexcel/includes/right-col.php on line 2