![]() |
#2
|
||||
|
||||
![]()
You cannot use non-contiguous ranges with ExportAsFixedFormat you would need to use the PDF printer driver to achieve that. e.g.
Code:
Sub PrintAsPDF() 'Graham Mayor - https://www.gmayor.com - Last updated - 14 Aug 2021 Dim sPrinter As String Dim sRange As String On Error GoTo lbl_Exit sPrinter = Application.ActivePrinter ActivePrinter = "Microsoft Print to PDF" sRange = InputBox("Enter the range of pages to be printed eg 1" & vbCr & _ "or 1-3" & vbCr & _ "or 1-3,6", "Print Pages") If sRange = "" Then MsgBox "No pages selected!", vbCritical, "Print Pages" GoTo lbl_Exit End If Application.PrintOut FileName:="", _ Range:=wdPrintRangeOfPages, _ Item:=wdPrintDocumentWithMarkup, _ copies:=1, _ Pages:=sRange, _ PageType:=wdPrintAllPages, _ collate:=True, _ Background:=False, _ PrintToFile:=False, _ PrintZoomColumn:=0, _ PrintZoomRow:=0, _ PrintZoomPaperWidth:=0, _ PrintZoomPaperHeight:=0 lbl_Exit: Application.ActivePrinter = sPrinter Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
word vba, word vba code, word vba macro |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save File with specific name from fields input. | PM1 | Word | 17 | 10-04-2020 07:22 PM |
Drag and Drop into an input range results in #REF! error | DJ0691 | Excel | 4 | 02-20-2020 10:16 AM |
![]() |
lipatin | Word VBA | 12 | 06-01-2018 12:13 AM |
Automatically copy/paste a form field onto new pages, with user input included | Pindar | Word VBA | 3 | 01-13-2017 11:49 AM |
![]() |
gn4619 | Word VBA | 9 | 10-27-2015 02:11 PM |