Hi Kristina ,
In VBA , the Date function returns the system date ; the Format function can be used to format any numeric value , which a date is , the way you want ; thus , a construct such as :
Format(Date , "yyyymmdd")
will return the text string 20150615 , which can then be appended to a path to form what ever is your requirement.
Narayan