I am working on an application that prints a large number of PDFs using PDF Creator. For each report, I need to print pages 1 to n where n needs to be determined dynamically. What's the best way to control the last page number (n) using VBA?

Is there a PDF Creator option that will control this, something like
.cOption("WHAT") = [n]

or do I need to control this via a command to Excel, something like
ExecuteExcel4Macro "PRINT(2,1,[n],1,,,,,,,,2,,,TRUE,,FALSE)"

If there are multiple approaches, what are the pros and cons?