VBA saving as pdf using 2 cells

[sastbury]

Hi, this is my first post because i have tried scouring the forums for help and it appears my coding levels are terrible. I have a whole workbook to print, i have it saving in the required place and with a correct filename using a cell. I just need to add the date from another cell to the filename

Private Sub CommandButton1_Click()
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\Stuart\Desktop" & ActiveSheet.Range("E8").Value & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
End Sub

Date format in cell E11 is DD/MM/YYYY

Thanks and sorry if its incredibly simple or not possible.

 

[njimack]

Re: Help with VBA saving as pdf using 2 cells

(Untested)...

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\Stuart\Desktop" & Range("E8") &" - " & Format(Range("E11"),"dd-mm-yyyy") &  ".pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= True