Solved

# VBA to split PDF File

Posted on 2009-05-12
3,023 Views
Is there a VBA script available which will split a multipage PDF file into individual page PDF Files?
0
Question by:rob546109
• 2

LVL 46

Accepted Solution

ID: 24383634
0

LVL 32

Expert Comment

ID: 24383972
a free method is PDFTK  http://www.pdfhacks.com/pdftk/

it is a command line app that you can call from VBS with the correct parameters.

actually wshexec may be better but i cant find my example.  http://www.microsoft.com/technet/scriptcenter/resources/qanda/may06/hey0519.mspx

Set oSH = CreateObject("WScript.Shell")

sFileInput = "C:\EE\test1.pdf"

sFileOutPrefix = "C:\ee\test1pg_%02d.pdf"

'build the comamnd line'

sPDFTK= "C:\Utils\pdftk.exe  " & sFileInput & " output  " & sFileOutPrefix

'---optionA-----'

oSH.Run sPDFTK, 1, True  'needs TRUE to wait until extern program has finished'

Set oSH = Nothing

'---------------OR---------'

'---option B---'

Set objExec = oSh.Exec(sPDFTK)

Do Until objExec.Status > 0    '0=running,1=finished,2=failed'

Wscript.Sleep 250

Loop

Set objExec = Nothing

set oSH = nothing

0

LVL 44

Expert Comment

ID: 24385470
If you want to use VBA, do you have access to Adobe Acrobat (the full version) on the system? If so, you can use VBA, and I can give you some pointers, but I need to know first if you have Acrobat.
0

LVL 32

Expert Comment

ID: 24391050

the VBS code can be used with Excel VBA with little change.
0

## Featured Post

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
The Adobe PDF proprietary file format is recognized as secure and formulated. But these PDF files are also prone to corruption and any external threat like virus attacks, improper storage can hit PDF file integrity.This type of damages can make cruc…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…