Printing PDF from Access - Choose number of pages with vba

[Kody_Devl]

Hi All,



I am using Access vba to print large numbers of PDF documents. I currently have two identical documents to print.
1 of the documents has 4 Pages
1 of the documents has 5 Pages (1-4 are the same in both documents)

I want to use the 5 Page document for both scenarios that I am processing. Then, from 1 document I could print 4 pages or 5 pages dynamically.

This is what I am using to print the PDFs but it prints ALL of the pages.

CreateObject("Shell.Application").Namespace(0).Par seName(strTO).InvokeVerb ("Print")

My question is, how can I dynamically select the number of pages to print (ie 1-4 or 1-5 pages)?

Many thanks

Kody_Devl

[Micron]

Apparently possible. If you don't get a direct solution here, suggest you research something like ms access vba choose pdf print page range

I didn't seem to get a whole lot of relevant results with that, so maybe it needs tweaking or maybe it's not a popular topic. I found this but it seems inconclusive.

http://www.vbaexpress.com/forum/show...n-pages-of-pdf

[ssanfu]

I did a search (DuckDuckGo) using criteria "print pdf from command line windows 10". One of the hits was this StackOverFlow post which led to PDFtoPrinter: Command-line PDF printing
It seems to be able to specify the page print range.....


Good luck with your project.....

[Kody_Devl]

Thanks

I will check it out