excel to PDF using Adobe Acrobat Pro 2017 not working

[kitsa]

Hi Guys,
I have a slight problem. I used to be able to have excel export to PDF (file name from a cell), this is no longer working since I have updated my Adobe Acrobat to Pro 2017. the PDF is printing but not saving to the file anymore. Can someone help me?
my code below:

Private Sub CommandButton1_Click()ActiveWorkbook.Save    Range("Q7").SelectChDir "Z:\ESS Contract Administration Reconciliation\One Steel" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Range("J10").Value _, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=False Range("E21").Select    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _        IgnorePrintAreas:=False    Range("J10").Select

Thanks Kitsa

 

[RoryA]

Do you get an error?

 

[kitsa]

No error just doesn't save to file

 

[RoryA]

That seems strange given that the code doesn't use Adobe at all. Are you sure you're looking in the right place for the pdf files (Your code doesn't specify a path, so it will be saved in whatever the current directory is).