x
Solved

# VBA to split PDF File

Posted on 2009-05-12
Medium Priority
4,125 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 33

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 33

Expert Comment

ID: 24391050

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

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.