Dynamically Name Excel File?

Antar Bolaeisk · 13 May 2009 at 22:03

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?

pallys · 13 May 2009 at 23:17

You could probably write a Visual Basic Macro to do it

Dolph · 13 May 2009 at 23:22

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

Antar Bolaeisk · 14 May 2009 at 21:30

Dolph said:
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.

Dolph · 15 May 2009 at 09:37

at it's simplest.

Code:

Sub save()
ActiveWorkbook.SaveAs Filename:="filename-" & Format(Date, "ddmm")
End Sub

Will save the file when the macro is activated and add today's date to the end of the filename.

Antar Bolaeisk · 15 May 2009 at 09:46

Brilliant, thank you very much.