Combine multiple PDFs and delete the original files VBA

Hi all --

Trying to automate a PDF export from a spreadsheet that may contain multiple print ranges. My method right now is to save each print range as a file name and add "_PG#" after each page, and then use Acrobat to combine the pdf's into one file and delete the files with "_PG#".

My code saves down the multiple files just fine. However, I cannot get this to combine the files... Any ideas?

Please Login or Register  to view this content.

Couldn't you just specify multiple pages to print out a combined file in the first place, instead of one page per file then combining the files?

Otherwise you'd likely have better luck asking how Acrobat works on an Adobe forum.