joshua1990
02-19-2018, 11:24 AM
Hey guys!
I am trying to implement an approach which creates an PDF in an defined folder.
The objective is to replace the existing PDF with the new one.
How is this possible?
My current approach looks like this:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Worksheets("TblOne").ExportAsFixedFormat Type:=xlTypePDF FileName:="Draft.pdf" Quality:=xlQualityStandardEnd Sub
Does anyone have an idea?
Best regards
Josh
I am trying to implement an approach which creates an PDF in an defined folder.
The objective is to replace the existing PDF with the new one.
How is this possible?
My current approach looks like this:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Worksheets("TblOne").ExportAsFixedFormat Type:=xlTypePDF FileName:="Draft.pdf" Quality:=xlQualityStandardEnd Sub
Does anyone have an idea?
Best regards
Josh