Solved

# VBA to split PDF File

Posted on 2009-05-12
3,155 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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…