I'm trying to save my file as a .pdf.
I am calling out the location and then the partial name after which the cell I want added to the end of the name.
I thought it was going to be a breeze but I’m stuck.
Any help would be greatly appreciated.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:="C:\CMM DATA\LayoutRequest & Range("AG3").Value & ".pdf", _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False
Bookmarks