Sub export_To_Pdf() 
strFilePath = "D:\test\" ' <<<<<<<<< to be changed
 Application.ScreenUpdating = False
On Error Resume Next
For j = 1 To Sheets.count
  strPdfName = Sheets(j).Name
  Sheets(j).Copy
  ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=strFilePath & strPdfName, _
  Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
  OpenAfterPublish:=False
       
  ActiveWorkbook.Close (False)
Next
Application.ScreenUpdating = True
End Sub