You would have to SaveAs to ‘rename’ a file. You can rename a file manually after it is closed, but not while the file is open. To ‘rename’ the file as with a single cell reference, you can do it with this macro.
Open the workbook
Change the ‘A’ in ‘Range(”A1″) to the cell reference you wish to SaveAs and copy this macro to the clipboard
Sub Save_As_A1()
ActiveWorkbook.SaveAs Filename:= _
“C:\” & Range(”A1″).Value & “.xls”, FileFormat:= _
xlNormal, Password:=”", WriteResPassword:= _
“”, ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub
Next, press ALT + F11
Insert > Module
Paste the macro into the module space to the right.
Close back to Excel
Go to Tools > Macro > Macros
Highlight this macro, if it is not already highlighted.
Click: ‘Options’
Select a letter to be used as a keyboard shortcut.
Close back to Excel.
Press CTRL + your shortcut letter to run the macro.
Gerald
You would have to SaveAs to ‘rename’ a file. You can rename a file manually after it is closed, but not while the file is open. To ‘rename’ the file as with a single cell reference, you can do it with this macro.
Open the workbook
Change the ‘A’ in ‘Range(”A1″) to the cell reference you wish to SaveAs and copy this macro to the clipboard
Sub Save_As_A1()
ActiveWorkbook.SaveAs Filename:= _
“C:\” & Range(”A1″).Value & “.xls”, FileFormat:= _
xlNormal, Password:=”", WriteResPassword:= _
“”, ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub
Next, press ALT + F11
Insert > Module
Paste the macro into the module space to the right.
Close back to Excel
Go to Tools > Macro > Macros
Highlight this macro, if it is not already highlighted.
Click: ‘Options’
Select a letter to be used as a keyboard shortcut.
Close back to Excel.
Press CTRL + your shortcut letter to run the macro.