ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ExportAsFixedFormat Options (https://www.excelbanter.com/excel-programming/393232-exportasfixedformat-options.html)

Robby

ExportAsFixedFormat Options
 
I have the control working well:

ActiveWorkbook.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
From:=1, _
To:=11, _
OpenAfterPublish:=False

What I need to do is instead of saving all 11 pages, I would like to save
1,2-4, and 7 for example. Is there any way to do this without creating
multiple PDFs?


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com