Save pages range as PDF by input box

RobertDany · #1 08-13-2021, 03:41 AM

Hello everyone,

This VBA code export the range of pages in pdf format, but you need to insert the range manually in the VBA editor window for each run of the code which may be annoying

Code:

Sub SavePageRangeAsPDF()

    ActiveDocument.ExportAsFixedFormat _
     OutputFileName:=CurrentFolder & "Robert" & ".pdf", _
     ExportFormat:=wdExportFormatPDF, _
range:=wdExportFromTo, From:=2, To:=4

End Sub

According to the previous code, how to design an input box which asks me to enter the range that I want to export such as: 5-8 or 5,9,12 or 1-7,12.

Thanks in advance

Similar Threads
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
Auto generate X pages from input	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
Save a range of pages as PDF	gn4619	Word VBA	9	10-27-2015 02:11 PM