Excel auto rename file

Hi experts,

Can excel save file name  according to  CELL A1  ?

I had a Template file named: Invoice.xls , everytime  after input all data   manually press  "save as....."  to rename  it  to      Invoice12345.xls   (file name according to the  invoice no.)
the invoice number  is input at  Cell A1  , is it possible  rename file  automatically  ?

Regards
Stanley
candychan611Asked:
Who is Participating?
 
VipulKadiaConnect With a Mentor Commented:
Try this macro...
Sub SaveFile()
    ThisWorkbook.SaveAs ThisWorkbook.Path & "\" & Sheet1.Cells(1, 1).Text & ".xls"
End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.