I have the following code to save a worksheet as a pdf when the button is pressed:
Code
Sub SavePDF()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="C:\9. Office12\msn plan share\2. Folders" & _
*******see below*******
Worksheets("ATO Days").Range("D2").Value & ".pdf", _
OpenAfterPublish:=True
End Sub
After 2. Folders\ I need the filename to be in this format but for the date 2 days after the current date:
2017\04 Apr\09 Apr **and whatever is in Worksheet "ATO Days", cell D2**
I tried putting the formatted dates into different cells on the sheet "ATO Days" (see attached) and referencing them for the filename, but to no avail.
I am very new to VBA.
Thank you for the help.