Save file with name and today's date

I need to use VBA to save files with a name and today's date, but the name needs to be taken from the text in Cell A2 in Sheet1

i.e. Cell A2 contain the following: Ro1234

Path is P:\Country\Client

So file needs to be saved:

P:\Country\Client\Ro1234 ddmmyy

Who is Participating?
Saqib Husain, SyedEngineerCommented:
should be something like this

activeworkbook.saveas "P:\Country\Client\" & range("A2") & format(date,"ddmmyy") & ".xlsx"
Martin LissOlder than dirtCommented:
… better answer already given ...
JagwarmanAuthor Commented:
Brilliant that's exactly what I need.
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.