Solved

VBA to split PDF File

Posted on 2009-05-12
6
3,023 Views
Last Modified: 2012-05-06
Is there a VBA script available which will split a multipage PDF file into individual page PDF Files?
0
Comment
Question by:rob546109
  • 2
6 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24383634
0
 
LVL 32

Expert Comment

by:Robberbaron (robr)
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 
 

Wscript.Echo objExec.StdOut.ReadAll()   'just for testing'

Set objExec = Nothing

set oSH = nothing

Open in new window

0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
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

by:Robberbaron (robr)
ID: 24391050
apologies. hadnt read the op fully.

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now