Can anyone recommend a better Macro to be able to do the following:
1. Choose where you can save the exported file
2. MAXIMUM quality of export
Here is what I'm currently using:
Sub ExportPDF()
ThisWorkbook.Sheets(Array("Sheet1")).Select
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="C:\Users\user\Export", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True
ThisWorkbook.Sheets(Array("Sheet1")).Select
End Sub
Thanks as always!
Bookmarks