extract pages from pdf

[rikvny02]

Hello
I already have the file name (column A), page numbers (column B). Is there a way to extract the pages from a PDF (actively open) using vba. I've found several post about extracting certain words but nothing about extracting and saving specific pages. Any help would be appreciated. Thank

save as C:/ wages

 

[John_w]

You could do this with the Acrobat API from VBA, however Acrobat Pro must be installed.

Alternatively, a command-line tool such as PDFtk Server, run from VBA, could be used, specifically the cat command. I don't think it can 'attach' to the currently open PDF, so you'd have to specify the full file name of the PDF in the code. The cat commands to create "north.pdf" and "ops.pdf" from specific pages in "input.pdf" would be:

PDFtk "C:\path\to\input.pdf" cat 10-16 output "C:\path\to\north.pdf"
PDFtk "C:\path\to\input.pdf" cat 32-155 171-178 180-192 output "C:\path\to\ops.pdf"

 

[rikvny02]

You could do this with the Acrobat API from VBA, however Acrobat Pro must be installed.

Alternatively, a command-line tool such as PDFtk Server, run from VBA, could be used, specifically the cat command. I don't think it can 'attach' to the currently open PDF, so you'd have to specify the full file name of the PDF in the code. The cat commands to create "north.pdf" and "ops.pdf" from specific pages in "input.pdf" would be:

PDFtk "C:\path\to\input.pdf" cat 10-16 output "C:\path\to\north.pdf"
PDFtk "C:\path\to\input.pdf" cat 32-155 171-178 180-192 output "C:\path\to\ops.pdf"

I do have pro. Thanks for the jump start