以特定顺序将多个页面导出为PDF [英] Exporting multiple pages to PDF in a specific order

问题描述

我正在尝试将两张不同工作簿的页面导出为PDF格式。

I am trying to export pages from two different sheets of a workbook as 1 PDF.

但是，我想要的页面是这样的顺序：1页从Sheet1，5页从Sheet2，2页从Sheet1。

However, I want the pages to be in this order: 1 page from Sheet1, 5 pages from Sheet2, 2 pages from Sheet1.

目前，我将这些作为3个独立的PDF导出，然后在另一个应用程序中合并。

At the moment I am exporting these as 3 seperate PDFs and then merging them afterwards in another application.

我一直在使用的代码在下面：

The code I have been using is below:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=sPath & quotept1filename, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, From:=1, To:=1, OpenAfterPublish:=False

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=sPath & quotept2filename, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, From:=2, To:=3, OpenAfterPublish:=False

Sheets("PPA Print Ready Quote").Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=sPath & optionsfilename, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, From:=1, To:=NumberOfOptions, OpenAfterPublish:=False

我如何按照我想要的顺序将它们打印成一个PDF？

How can I get them to print as one PDF in the order I want?

推荐答案

这可能看起来不是最好的方式，但我个人使用一个这样的PrimoPDF驱动程序来做到这一点。通过打印PrimoPDF所需的所有页面，您将以与发送到标准打印机的顺序相同的顺序获取一个pdf文件。

It may not seem like the best way, but I personally use a driver such a PrimoPDF to do this. By printing all the pages required to PrimoPDF you will gain one pdf file in the same order that it would appear if you were sending to a standard printer.

可以下载免费在这里 http://www.primopdf.com/

这篇关于以特定顺序将多个页面导出为PDF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！