ExportAsFixedFormat Options

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ExportAsFixedFormat? 4
Selecting multiple sheets to print to PDF 7
Print to PDF 1
PDF basics 1
save excel 2007 worksheet as pdf in macro 2
Confirm save file 1
PDF the Excel Report 3
Looping and pdf-making 4

Top