最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

excel - ExportAsFixedFormat PDF Quality issue - Stack Overflow

programmeradmin4浏览0评论

I am trying to set the quality of PDF output to xlQualityMinimum so the PDF size is smaller, however when I change from xlQualityStandard to xlQualityMinimum the output PDF ignores the margins and prints outside of the specified areas.

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=sPDF, Quality:=xlQualityMinimum, From:=1, To:=iLast, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False

I tried changing all of the various ExportAsFixedFormat properties, but the issue remains with xlQualityMinimum. xlQualityStandard prints as expected and looks like Print Preview.

发布评论

评论列表(0)

  1. 暂无评论