Dynamically Name Excel File?

[Antar Bolaeisk]

Howdy,

Just wondering if it's possible to dynamically name a file for saving in excel:

For example

filename-current date.xlsx

Where the current date changes to match todays date?

 

[Antar Bolaeisk]

as above, it can be done easily in vba, will try and post full solution when i'm not on my phone.

Even if you could point me in the way of some tutorials that would be brilliant.

 

[Antar Bolaeisk]

Brilliant, thank you very much.